Forum Discussion
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...
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:
Yes, I highlighed A4 to C38
Change it to A5:C38
- thanks
Thanks. I should have seen it in your screenshots, but having the workbook made it easier. Cell A13 contains an incorrect date:
Once you correct that, the chart will look as intended,
I'd still like to see a copy of the workbook itself.
- That was a sample of data & sample chart
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.