Microsoft Office Tutorials and References
In Depth Information
Figure 8-21: Placing a data series on the secondary axis.
Figure 8-22 illustrates the newly added axis to the right of the chart. Any data series on the secondary
axis has its vertical axis labels shown on the right.
Figure 8-22: Thanks to the secondary axis, both trends are clearly defined.
Again, changing the chart type of any one of the data series can help in comparing the two trends. In
Figure 8-23, the chart type for the People Count trend has been changed to a column. Now you can
easily see that although the number of people went down in November and December, the
percentage of labor cost continues to rise.
Figure 8-23: Changing the chart type of one data series can underscore comparisons.
Technically, it doesn’t matter which data series you place on the secondary axis.
A general rule is to place the problem data series on the secondary axis. In this scenario,
because the data series for percentage of labor cost seems to be the problem, we place
that series on the secondary axis.