How to create two vertical axes on the same side

Excel 365
If you need to display two different data series for the one- or compatible-time ranges that have different value scales, you can add the secondary vertical axis.
Two vertical axes on the same side in Excel 365

By default, Excel creates a chart with the primary horizontal axis at the bottom and with the primary vertical axis at the left side of the plot area (shown in orange in this example). When you add the secondary vertical axis adds at the right side (shown in blue in the example):

Two vertical axes in Excel 365

See how to add the secondary horizontal axis and display both horizontal axes on the same side for more details.

Add the secondary vertical axis

To add a secondary vertical axis, do the following:

   1.   Select the data series which you want to see using the secondary vertical axis.

   2.   Do one of the following:

  • Right-click in the data series and choose Format Data Series... in the popup menu:
    Format data series in popup menu Excel 365

    On the Format Data Series pane, in the Series Options tab, select the Secondary Axis option instead of the Primary Axis:

    Secondary Axis in Format Data Series pane Excel 365
  • Right-click on the selection and choose Change Series Chart Type... in the popup menu:
    Change Series Chart Type in Excel 365

    In the Change Chart Type dialog box, select the Secondary Axis option for the appropriate data series:

Secondary Axis in Change Chart Type dialog box Excel 365

Excel adds the secondary vertical axis for the selected data series:

Secondary vertical axis in Excel 365

Display dual vertical axis on one side

   1.   Select the vertical axis that you want to move to the opposite side of the plot area, right-click on it and choose Format Axis... in the popup menu:

Format Axis popup in Excel 365

   2.   On the Format Axis pane, in the Axis Options tab, in the Labels section, choose the appropriate option from the Label Position drop-down list:

Label Position in Format Axis pane Excel 365
  • Next to Axis (used by default) shows the primary vertical axis on the left side of the plot area, the secondary vertical axis on the right side of the plot area.
  • High, shows the primary axis in the highest values of the data, on the right side:
    Two vertical axes on the right side Excel 365
  • Low, shows the secondary axis in the lowest values of the data, on the left side:
    Two vertical axes on the left side Excel 365
  • None, hide labels for the axis. You still can select it, change its options, but can't see the labels.

See also this tip in French: Comment créer deux axes verticaux du même côté.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more