Forum Discussion
secondary axis option not available on mac
Hi everyone, I need some help. I have recently changed to a Mac and I have the Excel version 16.16.5 for Mac. I am looking to create a progress pie chart that basically is using a doughnut shape ...
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.
this was helpful but then how do I make that second data series a line rather than a bar?
- That's a great question!
