Microsoft Office Tutorials and References
In Depth Information
Although the name is fancy, comparative trending is a simple concept. You chart two or more data
series on the same chart so that the trends from those series can be visually compared. In this section,
you walk through a few techniques that allow you to build components that present comparative
Creating side-by-side time comparisons
Figure 8-13 shows a chart that presents a side-by-side time comparison of three time periods. With this
technique, you can show different time periods in different colors without breaking the continuity of
the overall trending.
Figure 8-13: You can show trends for different time periods side by side.
1. To create this type of chart, structure your source data similar to the structure shown in
Note that instead of placing all the data into one column, you’re staggering the data into
respective years. This tells the chart to create three separate lines (allowing for the three
2. Select the entire table and create a line chart.
This creates the chart shown in Figure 8-13.
3. If you want to get a bit fancy, click the chart to select it and then right-click. Select Change
Chart Type from the context menu that opens.
4. When the Change Chart Type dialog box opens, select Stacked Column Chart.
As you can see in Figure 8-15, your chart now shows the trending for each year in columns.