Microsoft Office Tutorials and References
In Depth Information
Column charts
T ABLE 2-2 COLUMN CHART SUBTYPES
Chart Type
Description
Clustered column
Standard Column chart.
Stacked column
Column chart with data series stacked.
100% stacked column
Column chart with data series stacked and expressed as
percentages.
3-D clustered column
Standard Column chart with a perspective look.
3-D stacked column
Column chart with a perspective look. Data series are
stacked and expressed as percentages.
3-D 100% stacked column
Column chart with a perspective look. Data series are
stacked and expressed as percentages.
3-D column
A column chart with multiple series arranged along a
third axis.
Figure 2-2 shows an example of a column chart that depicts annual sales for two
products. From this chart, it is clear that Sprocket sales have always exceeded
Widget sales. In addition, Widget sales have been declining over the years, whereas
Sprocket sales are increasing.
Figure 2-2: This column chart compares sales for two
products.
The same data, in the form of a stacked-column chart, is shown in Figure 2-3.
This chart has the added advantage of depicting the combined sales over time. It
shows that total sales have remained relatively steady over the years, but the relative
proportions of the two products have changed.
Search JabSto ::




Custom Search