How to add a Secondary Vertical Axis

Jorge López 20 Reputation points
2025-09-07T17:44:12.84+00:00

I am running Excel Version 16.100.3 for Macs and want to add a secondary vertical axis to a chart. I have two data series, and under Chart Design\Add Chart Element\Axes I don't see the Secondary Vertical axis.

Other problem is that in spite of having selected all the data series the second set of data is not shown (or plotted) in the chart.

I have tried Help, but the guide given in Help are of no use.

Can someone help?

Thanks,

Jorge

Microsoft 365 and Office | Excel | Other | MacOS
0 comments
Answer accepted by question author
Jeronimo Fuerte 45,750 Reputation points Independent Advisor
2025-09-07T19:12:37.8266667+00:00

Hi! Sorry to hear that you have troubles with this, have you tried like this:

  1. Click the chart once, then click the data series you want on the second axis.
  2. Press ⌘+1 to open Format Data Series.
  3. In Series Options, set Plot Series On > Secondary Axis.
  4. If needed, click the new axis to format its scale.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.