Jan 04 2019 11:43 AM
Jan 04 2019 11:43 AM
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 pie chart with data on 2 axis. I don't seem to be able to find anywhere the secondary axis. I checked all advice I could find on Google but without any success. The secondary axis is not available in Format Data Series > Series Options or Add Chart Element > Axis Titles (which does not exist).
Can anyone help?
Feb 01 2019 12:53 PM
I have a similar problem, but with an ordinary line chart.
I have used secondary axes before in Excel, and I think it was in Office 2011 for Mac, but I can't be sure.
The "Help" page tells how you can add a secondary axis in Word for Mac, but not Excel!
That seems ridiculous.
I am running Microsoft Excel for Mac, Version 16.21.1 (190123), in Office 365.
Using a new iMac Pro running MacOS 10.14.3 (the latest version)
Jan 08 2020 08:26 AM
Jan 08 2020 08:40 AM
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.
Feb 18 2020 07:57 PM
I think in the original question posted the user describes going through the exact same steps you're talking about, but it's not showing up on the Mac version. I'm having the same issue. When the format data series box pops up it does not show primary and secondary axes options. @McXcel
Mar 22 2021 05:42 PM
Nov 05 2021 08:41 AM
I need a second horizontal axis. Y axis remains the same but the timeline (dates) on the horizontal axis is different MS Office 2019.
Nov 05 2021 10:59 AM
What I did was select the data and on format data series you can click "plot series on secondary axis" then you can go to chart elements and click on axes to let you change if you want it to be vertical or horizontal. Hope this helps. @Pongajim
Jan 03 2022 12:33 PM
From another website, I just tried this and it worked. It is not intuitive because you first have to plot the data on a secondary vertical axis (which is not what you want), when you have selected the dataset you want on the secondary x axis (horizontal axis). However, when you tell excel to plot the data on the secondary vertical axis, and then look under "Add chart elements" when in "Chart Design" mode, then you can select "Axes" and both primary and secondary vertical and horizontal axes are an option, and so click on the secondary x axis.
To add a secondary horizontal axis, do the following:
1. Add the secondary vertical axis to any of the data series (see How to create two vertical axes on the same side).
2. Select the data series which you want to see using the secondary horizontal axis.
3. On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element drop-down list
Choose the Axes list and then click Secondary Horizontal