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 blue in the example below). When you add the secondary vertical axis, Excel adds it at the right side (shown in orange):

Two vertical axes in Excel 365

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

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 (changes nothing for the secondary vertical axis):
    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 (changes nothing for the primary vertical axis):
    Two vertical axes on the left side Excel 365
  • None, hide labels for the axis. You still can select the axis, 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é.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.