Add a secondary axis to a chart

Which Office program are you using?


Word

When the values in a chart vary widely from data series (data series: A 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.

A chart with a secondary axis

Do any of the following:

ShowAdd a secondary axis

  1. On the View menu, click Print Layout.
  2. 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 marker (data marker: 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 series (data series: A 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.

  1. Under Current Selection, click Format Selection.

Charts tab, Current Selection group

  1. In the navigation pane, click Axis.
  2. Click Secondary axis, and then click OK.

To add more data series to the secondary axis, repeat this procedure.

ShowAdd an axis title for a secondary axis

  1. On the View menu, click Print Layout.
  2. Click the chart, and then click the Chart Layout tab.
  3. Under Labels, click Axis Titles, point to Secondary Horizontal Axis Title or Secondary Vertical Axis Title, and then click the option that you want.

Chart Layout tab, Labels group

  1. Select the text in the Axis Title box, and then type an axis title.

ShowAdd an axis label for a secondary axis

  1. On the View menu, click Print Layout.
  2. Click the chart, and then click the Chart Layout tab.
  3. Under Axes, click Axes, point to Secondary Horizontal Axis or Secondary Vertical Axis, and then click the option that you want.

Chart Layout tab, Axes group

See also

Change a chart

Create a combination chart

PowerPoint

When the values in a chart vary widely from data series (data series: A 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.

A chart with a secondary axis

Do any of the following:

ShowAdd a secondary axis

  1. 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 marker (data marker: 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 series (data series: A 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.

  1. Under Current Selection, click Format Selection.

Charts tab, Current Selection group

  1. In the navigation pane, click Axis.
  2. Click Secondary axis, and then click OK.

To add more data series to the secondary axis, repeat this procedure.

ShowAdd an axis title for a secondary axis

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Labels, click Axis Titles, point to Secondary Horizontal Axis Title or Secondary Vertical Axis Title, and then click the option that you want.

Chart Layout tab, Labels group

  1. Select the text in the Axis Title box, and then type an axis title.

ShowAdd an axis label for a secondary axis

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Axes, click Axes, point to Secondary Horizontal Axis or Secondary Vertical Axis, and then click the option that you want.

Chart Layout tab, Axes group

See also

Change a chart

Create a combination chart

Excel

When the values in a chart vary widely from data series (data series: A 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.

A chart with a secondary axis

Do any of the following:

ShowAdd a secondary axis

  1. 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 marker (data marker: 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 series (data series: A 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.

  1. Under Current Selection, click Format Selection.

Charts tab, Current Selection group

  1. In the navigation pane, click Axis.
  2. Click Secondary axis, and then click OK.

To add more data series to the secondary axis, repeat this procedure.

ShowAdd an axis title for a secondary axis

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Labels, click Axis Titles, point to Secondary Horizontal Axis Title or Secondary Vertical Axis Title, and then click the option that you want.

Chart Layout tab, Labels group

  1. Select the text in the Axis Title box, and then type an axis title.

ShowAdd an axis label for a secondary axis

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Axes, click Axes, point to Secondary Horizontal Axis or Secondary Vertical Axis, and then click the option that you want.

Chart Layout tab, Axes group

See also

Change a chart

Create a combination chart

 
 
Applies to:
Excel for Mac 2011, PowerPoint for Mac 2011, Word for Mac 2011