-
Select a chart to open Chart Tools.
-
Select Design > Change Chart Type.
-
Select Combo > Cluster Column - Line on Secondary Axis.
-
Select Secondary Axis for the data series you want to show.
-
Select the drop-down arrow and choose Line.
-
Select OK.
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.
Do any of the following:
Add a secondary axis
-
This step applies to Word for Mac only: 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 Chart Design tab on the ribbon.
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.
-
Click Add Chart Element > Axes > and select between Secondary Horizontal or Second Vertical.
Add an axis title for a secondary axis
-
This step applies to Word for Mac only: 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 Chart Design tab on the ribbon.
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.
-
Click Add Chart Element > Axis Titles > and select between Secondary Horizontal or Second Vertical.