Microsoft Office Tutorials and References
In Depth Information
Creating stacked time comparisons
The stacked time comparison places two series on top of each other instead of side-by-side.
Although this approach removes the benefit of having an unbroken overall trending, you get the
benefit of an at-a-glance comparison within a compact space. Figure 8-17 illustrates a common
stacked time comparison.
Figure 8-17: A stacked time comparison allows you to view and compare two years of data in a compact space.
1. Create a new structure and add data to it like the one shown in Figure 8-18.
Figure 8-18: Start with a structure containing the data for two time periods.
2. Highlight the entire structure and create a column chart.
3. Select and right-click any of the bars for the 2010 data series and then choose Change Series
4. When the Change Chart Type dialog box opens, select the Line type.
This technique works well with two time series. You generally want to avoid stacking
any more than that. Stacking more than two series often muddies the view and
causes users to constantly reference the legend to keep track of the series they’re