Forum Discussion
Patricia_Bloj
Jan 04, 2019Copper Contributor
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 ...
McXcel
Jan 08, 2020Copper Contributor
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.