Microsoft Office Tutorials and References
In Depth Information
Figure 2-4 shows the same sales data plotted as a 100% stacked-column chart.
This chart type shows the relative contribution of each product by year. Notice that
the value axis displays percentage values, not sales amounts. This chart provides no
information about the actual sales volumes. This type of chart is often a good
alternative to using several pie charts. Instead of using a pie to show the relative sales
volume in each year, the chart uses a column for each year.
Figure 2-3: This stacked-column chart displays sales by
product and depicts the total sales.
Figure 2-4: This 100% stacked-column chart displays
annual sales as a percentage.
The data is plotted with a 3-D column chart in Figure 2-5. Many people use this
type of chart because it has more visual pizzazz. Although it may be more appealing
visually, this type of chart often makes it difficult to make precise comparisons
because of the distorted perspective view. Generally speaking, a 3-D column chart is
best used when the goal is to show general trends rather than precise comparisons.
A bar chart is essentially a column chart that has been rotated 90 degrees clockwise.
One distinct advantage to using a bar chart is that the category labels may be easier
to read. Figure 2-6 shows a bar chart that displays a value for each of ten survey