When the values in a chart vary widely from
data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.
to data series, you can plot one or more data series on a secondary axis. A secondary axis can also be used as part of a combination chart when you have mixed types of data (for example, price and volume) in the same chart.
In this chart, the primary vertical axis on the left is used for sales volumes, whereas the secondary vertical axis on the right side is for price figures.
Do any of the following:
 | Add a secondary axis |
-
On the View menu, click Print Layout.
-
In the chart, select the data series that you want to plot on a secondary axis, and then click the Chart Layout tab.
For example, in a line chart, click one of the lines in the chart, and all the
data markers A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a cell on a sheet. Data markers of the same color constitute a data series.
of that
data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.
become selected.
-
Under Current Selection, click Format Selection.

-
In the navigation pane, click Axis.
-
Click Secondary axis, and then click OK.
To add more data series to the secondary axis, repeat this procedure.
 | Add an axis title for a secondary axis |
-
On the View menu, click Print Layout.
-
Click the chart, and then click the Chart Layout tab.
-
Under Labels, click Axis Titles, point to Secondary Horizontal Axis Title or Secondary Vertical Axis Title, and then click the option that you want.

-
Select the text in the Axis Title box, and then type an axis title.
 | Add an axis label for a secondary axis |
-
On the View menu, click Print Layout.
-
Click the chart, and then click the Chart Layout tab.
-
Under Axes, click Axes, point to Secondary Horizontal Axis or Secondary Vertical Axis, and then click the option that you want.
