Home

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

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