How to Filter PivotCharts in Excel for Mac
Question details
Users need to find a way to filter PivotCharts on Mac since the standard on-chart filter controls present in the Windows version are missing.

- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Attempting to filter data directly from a PivotChart to analyze specific metrics.
- Observed behavior
- PivotCharts in Excel for Mac do not display the interactive chart filter controls found in Windows versions, leaving users unable to filter directly from the chart.
Ensure your PivotChart is actively linked to a source PivotTable in your workbook, as you will need to apply the filters to the underlying data rather than the chart graphic itself.
Filter the Connected PivotTable Directly
Apply filters directly to the source PivotTable, which will dynamically update the connected PivotChart in real time.
Because Excel for Mac does not include on-chart filter controls, the most direct workaround is to manipulate the data at its source. Since the PivotTable and PivotChart are linked, any formatting or filtering applied to the table automatically reflects in the chart.
Navigate to the worksheet that contains the PivotTable connected to your PivotChart.
Click the drop-down arrows next to the Row Labels or Column Labels directly on the PivotTable, and select or deselect the data points you wish to view.
Click 'OK' or close the filter menu. The PivotChart will instantly update to show only the filtered data.
If your chart and table are on the same sheet but far apart, go to the 'View' tab and click 'Split' or 'Freeze Panes' to keep the table filters visible while watching the chart update.

Use Slicers for Interactive Filtering
Insert slicers to create visual, click-to-filter buttons that control both the PivotTable and PivotChart simultaneously.
Analyze Data Without Limitations in WPS Office
If you are frustrated by platform-specific missing features in Microsoft Office, try WPS Office. It provides a lightweight, fast, and free alternative with comprehensive spreadsheet tools, full support for PivotTables, and excellent file compatibility across Windows and Mac.
- 1. Download and Install WPS Office: Visit the official WPS website and download the free version for Mac or Windows.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbook.
- 3. Manage PivotTables Seamlessly: Use the familiar ribbon interface to insert, edit, and filter your PivotTables and charts easily.

Frequently Asked Questions
Why are the filter buttons missing from my PivotChart on Mac?
Unlike the Windows version of Excel, Excel for Mac does not natively support on-chart filter buttons for PivotCharts. This is a known platform difference, requiring Mac users to filter the underlying PivotTable directly or use slicers instead.
Are slicers fully supported in Excel for Mac?
Yes, slicers are fully supported in modern versions of Excel for Mac. They act as an excellent visual alternative to traditional filters and can control both PivotTables and their linked PivotCharts simultaneously.
How can I view both the PivotTable and PivotChart if they don't fit on my screen?
You can use the 'Freeze Panes' or 'Split' features found under the View tab. Alternatively, you can click 'New Window' in the View tab to open a second view of the same workbook, allowing you to put the table on one monitor and the chart on another.




