When the values in a 2-D chart vary widely from data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series.
- On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), click the data series that you want to plot along a secondary value axis.
- On the Format menu, click Selected Data Series.
- On the Axis tab, click Secondary axis.
Tip After you add a secondary value axis to a chart, you can also add a secondary category (x) axis, which may be useful in an xy (scatter) chart. Select a chart that displays the secondary value axis, and then click Chart Options on the Chart menu. On the Axes tab, select the Category (X) axis check box.