Forum Discussion
secondary axis option not available on mac
What I found to work is selecting all the data from the chart, then going to insert a chart and choosing a "combo chart". When you do this, do not pick the first option. I believe I had to pick the second option for it to allow me to have a secondary axis. Once I did this, it gave me the option under chart elements to add/delete the secondary axis. It gives you an option to do a secondary horizontal as well as a vertical. If this doesn't help, I believe looking into the data series menu and adding another legend. That whole menu is quite confusing to me, but when I looked to see what the difference was it seemed that there was a second legend option and it added another y-axis series. I hope this helps y'all!!!!! I am using mac version 16.55.
steelmmrThat was absolutely the solution that I needed, thank you. It seems weird that this option is not available on the standard bar graph.
I made some edits and somehow ended up with 2 lines, but couldn't find where/how. What I'd really like is 2 bars vs 1 set of bars and one line.
Thanks again!