Forum Discussion

JohnV2021's avatar
JohnV2021
Copper Contributor
Jun 07, 2021
Solved

Excel XY Scatter plot - secondary vertical axis

Is there a way to add a secondary vertical axis to an XY (Scatter) graph? This would be extremely useful for plotting 2 sets of y-values (with different ranges of values) for the same set of x-value...
  • HansVogelaar's avatar
    Jun 07, 2021

    JohnV2021 

    Click on the chart.

    Click on the second series, or select it from the Chart Elements dropdown on the Format tab of the ribbon (under Chart Tools).

    Click 'Format Selection' on the Format tab.

    Select 'Secondary axis' on the 'Format Data Series' task pane.

    That's all!

    Example, before and after changing the axis:

Resources