secondary axis option not available on mac

%3CLINGO-SUB%20id%3D%22lingo-sub-309132%22%20slang%3D%22en-US%22%3Esecondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309132%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20help.%20I%20have%20recently%20changed%20to%20a%20Mac%20and%20I%20have%20the%20Excel%20version%2016.16.5%20for%20Mac.%20I%20am%20looking%20to%20create%20a%20progress%20pie%20chart%20that%20basically%20is%20using%20a%20doughnut%20shape%20pie%20chart%20with%20data%20on%202%20axis.%20I%20don't%20seem%20to%20be%20able%20to%20find%20anywhere%20the%20secondary%20axis.%20I%20checked%20all%20advice%20I%20could%20find%20on%20Google%20but%20without%20any%20success.%20The%20secondary%20axis%20is%20not%20available%20in%20Format%20Data%20Series%20%26gt%3B%20Series%20Options%20or%20Add%20Chart%20Element%20%26gt%3B%20Axis%20Titles%20(which%20does%20not%20exist).%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329544%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329544%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20similar%20problem%2C%20but%20with%20an%20ordinary%20line%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20secondary%20axes%20before%20in%20Excel%2C%20and%20I%20think%20it%20was%20in%20Office%202011%20for%20Mac%2C%20but%20I%20can't%20be%20sure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22Help%22%20page%20tells%20how%20you%20can%20add%20a%20secondary%20axis%20in%20Word%20for%20Mac%2C%20but%20not%20Excel!%3C%2FP%3E%3CP%3EThat%20seems%20ridiculous.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHbarr%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20running%20Microsoft%20Excel%20for%20Mac%2C%20Version%2016.21.1%20(190123)%2C%20in%20Office%20365.%3C%2FP%3E%3CP%3EUsing%20a%20new%20iMac%20Pro%20running%20MacOS%2010.14.3%20(the%20latest%20version)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096925%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096925%22%20slang%3D%22en-US%22%3EThe%20Help%20is%20confusing--only%20the%20first%20step%20is%20for%20Word%20only.%20The%20rest%20of%20the%20steps%20apply%20to%20both%20Excel%20and%20Word.%20Unfortunately%2C%20if%20you%20follow%20the%20directions%20they%20still%20don't%20work.%20On%20Mac%2C%20the%20option%20to%20add%20a%20secondary%20axis%20is%20apparently%20absent.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096953%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F276852%22%20target%3D%22_blank%22%3E%40hbarr%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F260572%22%20target%3D%22_blank%22%3E%40Patricia_Bloj%3C%2FA%3E%26nbsp%3BI%20figured%20out%20how%20to%20do%20this%20on%20Mac.%20The%20help%20is%20just%20wrong%20(it%26nbsp%3B%3CEM%3Eshould%3C%2FEM%3E%20be%20right%2C%20but%20the%20menu%20apparently%20has%20a%20bug).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Select%20the%20series%20you%20want%20to%20add%20a%20secondary%20axis%20for%3C%2FP%3E%3CP%3E2.%20Right-click%20(two-finger%20tap)%20on%20the%20series%3C%2FP%3E%3CP%3E3.%20Select%20%22Format%20Data%20Series...%22%3C%2FP%3E%3CP%3E4.%20In%20helper%20window%20on%20the%20right%2C%20you%20can%20choose%20to%20plot%20the%20series%20on%20primary%20or%20secondary%20axis.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181001%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181001%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20in%20the%20original%20question%20posted%20the%20user%20describes%20going%20through%20the%20exact%20same%20steps%20you're%20talking%20about%2C%20but%20it's%20not%20showing%20up%20on%20the%20Mac%20version.%20I'm%20having%20the%20same%20issue.%20When%20the%20format%20data%20series%20box%20pops%20up%20it%20does%20not%20show%20primary%20and%20secondary%20axes%20options.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510669%22%20target%3D%22_blank%22%3E%40McXcel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182338%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182338%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562751%22%20target%3D%22_blank%22%3E%40ntroy22273%3C%2FA%3E%26nbsp%3BOP%20was%20using%20the%20app%20menu%2C%20I%20think%2C%20which%20doesn't%20work.%20You%20have%20to%20select%20the%20series%20in%20the%20graph%20and%20use%20the%20context%20menu%2C%20as%20I%20described%2C%20then%20go%20to%20the%20helper%20window.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1749473%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1749473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510669%22%20target%3D%22_blank%22%3E%40McXcel%3C%2FA%3E%26nbsp%3BThis%20worked%20great%2C%20thanks!%20They%20need%20to%20change%20the%20Microsoft%20help%20page%20to%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2228732%22%20slang%3D%22en-US%22%3ERe%3A%20secondary%20axis%20option%20not%20available%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228732%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20on%20word%20and%20I%20found%20that%20clicking%20on%20the%20inside%20of%20the%20chart%20area%20(I.e.%20where%20the%20bars%2Flines%20are%2C%20not%20the%20outside%20with%20the%20numbers!)%20and%20clicking%20the%20white%20square%20in%20the%20middle%20of%20the%20secondary%20vertical%20axis%2C%20and%20dragging%20it%20to%20the%20left%20(so%20that%20there%20is%20actually%20space%20on%20the%20right%20side%20of%20the%20graph)%20helped.%20It%20allows%20space%20for%20there%20to%20actually%20be%20an%20axis%20title%20on%20the%20right%20side%20of%20the%20secondary%20axis.%20Before%20I%20done%20this%20there%20was%20no%20option%20for%20secondary%20axis%20title%20from%20add%20chart%20element%20%26gt%3B%20axis%20titles.%20After%20shuffling%20it%20around%20the%20secondary%20axis%20title%20option%20was%20made%20available%20from%20add%20chart%20element%20%26gt%3B%20axis%20titles%20%26gt%3B%20secondary%20vertical.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps!%3C%2FLINGO-BODY%3E
Occasional Visitor

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 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?

Thanks

10 Replies

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.

 

Hbarr

 

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)

 

 

The Help is confusing--only the first step is for Word only. The rest of the steps apply to both Excel and Word. Unfortunately, if you follow the directions they still don't work. On Mac, the option to add a secondary axis is apparently absent.

@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.

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 

@ntroy22273 OP was using the app menu, I think, which doesn't work. You have to select the series in the graph and use the context menu, as I described, then go to the helper window.

@McXcel This worked great, thanks! They need to change the Microsoft help page to this.

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!

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.

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 

 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