SOLVED

Excel XY Scatter plot - secondary vertical axis

New Contributor

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-values on the same graph.

You would have 1 graph with a different y-axis on the left & right side of the graph.

All the examples seem to be for Combo - Clustered Column - Line, but not the XY Scatter.

Is this possible?

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

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

S0486.png

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

S0487.png

That's all!

Example, before and after changing the axis:

Before.pngAfter.png

Awesome! I got it to work with your help. Thanks so much!