Microsoft Office Tutorials and References
In Depth Information
Column and Bar Chart Variations
Figure 8-16: Rearranging the data and inserting blank rows facilitates
comparisons of the same month.
Figure 8-17: This chart displays single columns as well as stacked columns.
Excel doesn’t provide a direct way to do this, but it’s fairly easy to do if you
arrange your data properly. This is a standard stacked-column chart generated from
the data in A1:D12. The gap width was set to 0. The chart actually has 11 categories,
although it appears to have only four.
Figure 8-18 shows a variation on the previous chart. In this case, the data need
not be arranged in any special way (as in the previous example). This is actually a
combination chart that uses two value axes. The Orders series is assigned to the left
value axis, and the other two series are assigned to the right value axis.
Because the series use different value axes, you can adjust the gap width
independently for the Orders series. In this example, the gap width is set to 50.