Pivot chart field buttons missing

[rowellswales]

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.  

[#2 · Accepted 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!

[#3]

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

[#4]

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