Secondary Axis not working on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1504886%22%20slang%3D%22en-US%22%3ESecondary%20Axis%20not%20working%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504886%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20able%20to%20add%20a%20secondary%20axis%20on%20a%20Mac.%20I've%20read%20the%20various%20help%20articles%20and%20discussions%20at%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9%23OfficeVersion%3DmacOS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9%23OfficeVersion%3DmacOS%3C%2FA%3E%3C%2FP%3E%3CP%3Eand%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fsecondary-axis-option-not-available-on-mac%2Fm-p%2F309132%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fsecondary-axis-option-not-available-on-mac%2Fm-p%2F309132%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20they%20don't%20address%20my%20issue%2C%20which%20is%20that%20the%20option%20just%20isn't%20available.%20I've%20attached%20screenshots%20of%20the%20menu%20and%20format%20panel%20(note%20that%20the%20data%20series%20is%20selected%20in%20both%20of%20them)%2C%20and%20the%20spreadsheet%20itself.%20Help%3F!%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I'm not able to add a secondary axis on a Mac. I've read the various help articles and discussions at:

 

https://support.microsoft.com/en-us/office/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e...

and 

https://techcommunity.microsoft.com/t5/excel/secondary-axis-option-not-available-on-mac/m-p/309132

 

and they don't address my issue, which is that the option just isn't available. I've attached screenshots of the menu and format panel (note that the data series is selected in both of them), and the spreadsheet itself. Help?!?

2 Replies

@BrendonTowle I note you have one line chart type (grey) and two scatter charts (blue and green). I suspect that if you only have one line, this it only can go on the primary axis. If you then put the "green" series on the primary axis as well and the "blue" series on the secondary axis, your graph will look like this (made on a Mac).

Screenshot 2020-07-06 at 17.13.00.png

Is that what you had in mind?

@Riny_van_Eekelen 

 

Yes, that is roughly what I had in mind, although the line/scatter inconsistency is an artifact of the experimenting I did trying to get this to work. It didn't work when I had three scatter series, either.

 

However, I see roughly the same results you do: I can put the green and/or blue series on a secondary axis, just not the grey one (regardless of whether any of the series are line or scatter). This is particularly stupid because since the grey series is just the ratio of the blue to green, it really is mathematically secondary. Whatever. I can get roughly what I want. Hopefully the Excel team can remove whatever restriction is preventing me from being able to do it in a way that makes sense to humans.

 

Thanks for your help!