Microsoft Office Tutorials and References
In Depth Information
CREATING A SECONDARY VALUE AXIS
Figure 3-25: Using a secondary value axis for the
Profit Margin series
Creating a chart with four axes is a bit tricky. To add two new value axes for this
1. Select the 2002 series.
2. Select Format
Selected Data Series and click the Axis tab in the Format
Data Series dialog box.
3. Choose the Secondary axis option. At this point, each of the series has its
own Y value axis (one on the left, one on the right) but they share a
common X value axis.
4. Access the Chart Options dialog box and select the Axes tab. This is where
you have the option to add a secondary value axis. This option is
available only if you’ve specified a secondary value axis for a series.
Figure 3-26: The two series vary in magnitude.