Microsoft Office Tutorials and References
In Depth Information
Column and Bar Chart Variations
Column and Bar Chart Variations
This section contains a number of examples that demonstrate how to create charts
that you may have thought were impossible. As you’ll see, the key is applying a few
charting tricks — and being creative.
Stacked-column chart variations
A stacked-column chart enables you to compare relative proportions of individual
items across categories. But this type of chart sometimes doesn’t quite do the job.
Figure 8-15 demonstrates the problem. The goal is to facilitate comparisons by
month, across the two years (compare January ’01 with January ’02, and so on).
Because of the data arrangement, this comparison is difficult to do. For example,
the January data is separated by five columns.
Figure 8-15: Comparing data for a specific month is difficult.
Figure 8-16 shows an improved version of this chart. Rearranging the data so
that the same months are contiguous, as well as inserting blank rows, solves the
problem. This chart also has its gap width set to 0. You may prefer to include an
additional blank row at the top and bottom of the series. Doing so would display a
gap before the January columns and after the June columns.
In some cases, you may want to compare a single-value column with a stacked
column. The chart in Figure 8-17, for example, displays Orders for each item, along
with a corresponding stacked column that depicts the Inventory amount with the In
Production amount.
Search JabSto ::




Custom Search