Part III: Creating Charts and Other Visualizations
FIGURE 20.18
This stacked column chart displays sales by product and depicts the total sales.
Figure 20.19 shows the same sales data plotted as a 100% stacked column chart. This chart
type shows the relative contribution of each product by month. Notice that the vertical
axis displays percentage values, not sales amounts. This chart provides no information
about the actual sales volumes, but such information could be provided using data labels.
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 20.19
This 100% stacked column chart displays monthly sales as a percentage.
