Forum Discussion
Secondary Axis not working on Mac
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).
Is that what you had in mind?
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!