Pivot Table Issues

How to Filter PivotCharts in Excel for Mac

Bushra ParveenBushra Parveen Nov 4, 2026 868 views

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.

How to Filter PivotCharts in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the Source PivotTable

Navigate to the worksheet that contains the PivotTable connected to your PivotChart.

2
Apply Table Filters

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.

3
View the Updated Chart

Click 'OK' or close the filter menu. The PivotChart will instantly update to show only the filtered data.

4
Organize Your Workspace

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.

Filter the Connected PivotTable Directly
Alternative Viewing: You can also open a new window from the View tab to display the PivotTable on one screen and the PivotChart on another.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website and download the free version for Mac or Windows.
  2. 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbook.
  3. 3. Manage PivotTables Seamlessly: Use the familiar ribbon interface to insert, edit, and filter your PivotTables and charts easily.
100% compatible with Microsoft Excel (.xlsx) formatsRobust PivotTable and chart analysis features without platform restrictionsFamiliar tabbed interface for a zero-learning-curve transitionCompletely free to use for essential spreadsheet tasks
microsoft office alternative - wps office

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.