Forum Discussion
secondary axis option not available on mac
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.
Add the secondary horizontal 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
Just chiming in to say that the Help text still has not been fixed, as of Excel 16.54 for Mac. Clicking on the data series, as mentioned above, does work, thanks for that. But hey Microsoft - it's surely not that hard to fix the manual?
Secondary axis is not available in Mac Excel 365 16.57 in Chart Design>Add Chart Element. And there is no option to add an axis in format. This is driving me nuts, because I have been able to add a secondary axis before but can't seem to find how to do it now.
drerle I had the same issue, but found that when you save the Excel file, the menu changes and you can add the secondary axis title(s).
