Forum Discussion

Patricia_Bloj's avatar
Patricia_Bloj
Copper Contributor
Jan 04, 2019

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 ...
Excel
Excel on Mac
swilson290's avatar
swilson290
Copper Contributor
Mar 23, 2021
I’m on word and I found that clicking on the inside of the chart area (I.e. where the bars/lines are, not the outside with the numbers!) and clicking the white square in the middle of the secondary vertical axis, and dragging it to the left (so that there is actually space on the right side of the graph) helped. It allows space for there to actually be an axis title on the right side of the secondary axis. Before I done this there was no option for secondary axis title from add chart element > axis titles. After shuffling it around the secondary axis title option was made available from add chart element > axis titles > secondary vertical.

I hope this helps!
  • Pongajim's avatar
    Pongajim
    Copper Contributor
    Nov 05, 2021

    I need a second horizontal axis. Y axis remains the same but the timeline (dates) on the horizontal axis is different MS Office 2019.

     

    Help please.

    • GLMac's avatar
      GLMac
      Copper Contributor
      Jan 03, 2022

       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

      Pongajim

      • bmacgreg's avatar
        bmacgreg
        Copper Contributor
        Feb 02, 2022

        GLMac 

        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?

    • gbm455's avatar
      gbm455
      Copper Contributor
      Nov 05, 2021

      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 

Resources