Forum Discussion
secondary axis option not available on mac
I have a similar problem, but with an ordinary line chart.
I have used secondary axes before in Excel, and I think it was in Office 2011 for Mac, but I can't be sure.
The "Help" page tells how you can add a secondary axis in Word for Mac, but not Excel!
That seems ridiculous.
Hbarr
I am running Microsoft Excel for Mac, Version 16.21.1 (190123), in Office 365.
Using a new iMac Pro running MacOS 10.14.3 (the latest version)
hbarr Patricia_Bloj I figured out how to do this on Mac. The help is just wrong (it should be right, but the menu apparently has a bug).
1. Select the series you want to add a secondary axis for
2. Right-click (two-finger tap) on the series
3. Select "Format Data Series..."
4. In helper window on the right, you can choose to plot the series on primary or secondary axis.
- thank you so much, this is the solution!
- this was helpful but then how do I make that second data series a line rather than a bar?
- That's a great question!
- This works! Thank you so much!
I think in the original question posted the user describes going through the exact same steps you're talking about, but it's not showing up on the Mac version. I'm having the same issue. When the format data series box pops up it does not show primary and secondary axes options. McXcel
ntroy22273 OP was using the app menu, I think, which doesn't work. You have to select the series in the graph and use the context menu, as I described, then go to the helper window.
