Microsoft Office Tutorials and References
In Depth Information
Trending with a secondary axis
In some trending components, you’ll have series that trend two very different units of measure. For
instance, in Figure 8-19, you have a table that shows a trend for People Count and a trend for % of
Figure 8-19: You often need to trend two very different units of measure, such as counts and percentages.
These are two very different units of measure that, when charted, produce the unimpressive chart
you see in Figure 8-20. Because Excel builds the vertical axis to accommodate the largest number,
the percentage of labor cost trending gets lost at the bottom of the chart. Even a logarithmic scale
doesn’t help in this scenario.
Figure 8-20: The trending for percentage of labor cost gets lost at the bottom of the chart.
Because the default vertical axis (or primary axis) doesn’t work for both series, the solution is to create
another axis to accommodate the series that doesn’t fit into the primary axis. This other axis is the
To place a data series on the secondary axis, follow these steps:
1. Right-click the data series and select Format Data Series.
The Format Data Series dialog box appears (see Figure 8-21).
2. In the Format Data Series dialog box, expand the Series Options section and then select the
Secondary Axis radio button.