SOLVED

Pivot chart field buttons missing

%3CLINGO-SUB%20id%3D%22lingo-sub-1503704%22%20slang%3D%22en-US%22%3EPivot%20chart%20field%20buttons%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503704%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20the%20most%20up%20to%20date%20version%20of%20Excel%20(Microsoft%20365)%20on%20a%20Mac.%20I%20have%20a%20pivot%20chart%20and%20I%20cannot%20add%20the%20field%20buttons%20on%20the%20chart.%20%26nbsp%3BI%20want%20to%20be%20able%20to%20change%20the%20data%20without%20having%20to%20go%20back%20to%20the%20original%20pivot%20table%20and%20changing%20the%20filters%20there.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503704%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1503716%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20chart%20field%20buttons%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F717754%22%20target%3D%22_blank%22%3E%40rowellswales%3C%2FA%3E%26nbsp%3BAs%20far%20as%20can%20determine%2C%20the%20show%2Fhide%20%22Field%20Buttons%22%20option%20is%20NOT%20supported%20by%20Excel%20for%20Mac.%20Windows%20only.%20Don't%20know%20why!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1503922%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20chart%20field%20buttons%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bthank%20you%2C%20that%E2%80%99s%20a%20pity%20as%20it%E2%80%99s%20useful%20in%20managing%20dashboards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1980141%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20chart%20field%20buttons%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1980141%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F717754%22%20target%3D%22_blank%22%3E%40rowellswales%3C%2FA%3E%26nbsp%3BI'm%20not%20a%20Mac%20user%2C%20but%20in%20non-Mac%20excel365%20you%20can%20get%20the%20same%20effect%20of%20the%20field%20buttons%20using%20slicers.%20Unfortunately%20the%20slicers%20work%20only%20if%20the%20chart%20is%20embedded%20in%20a%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am working on the most up to date version of Excel (Microsoft 365) on a Mac. I have a pivot chart and I cannot add the field buttons on the chart.  I want to be able to change the data without having to go back to the original pivot table and changing the filters there.  

 

 

 

3 Replies
Best Response confirmed by rowellswales (New Contributor)
Solution

@rowellswales As far as can determine, the show/hide "Field Buttons" option is NOT supported by Excel for Mac. Windows only. Don't know why!

@Riny_van_Eekelen thank you, that’s a pity as it’s useful in managing dashboards.

@rowellswales I'm not a Mac user, but in non-Mac excel365 you can get the same effect of the field buttons using slicers. Unfortunately the slicers work only if the chart is embedded in a sheet.