Add a secondary axis to a chart

Which Office program are you using?

Word

PowerPoint

Excel

Word

When the values in a chart vary widely from 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:

Add 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 of that data series become selected.

  3. Under Current Selection, click Format Selection.

    Charts tab, Current Selection group

  4. In the navigation pane, click Axis.

  5. 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

  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

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

Add 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 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:

Add 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 of that data series become selected.

  2. Under Current Selection, click Format Selection.

    Charts tab, Current Selection group

  3. In the navigation pane, click Axis.

  4. 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

  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

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

Add 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 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:

Add 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 of that data series become selected.

  2. Under Current Selection, click Format Selection.

    Charts tab, Current Selection group

  3. In the navigation pane, click Axis.

  4. 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

  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

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

Add 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: PowerPoint for Mac 2011, Word for Mac 2011, Excel for Mac 2011



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language