Forum Discussion
JohnV2021
Jun 07, 2021Copper Contributor
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...
- Jun 07, 2021
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:
HansVogelaar
Jun 07, 2021MVP
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:
rvc23
Aug 09, 2023Copper Contributor
HansVogelaar is there any update to this with Office 365? I am facing the same problem, but the Secondary Axis is no longer visible in the way described in this incident.
- HansVogelaarAug 09, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?