Pivot Table Issues

Fix a PivotChart That Does Not Update After a Slicer Selection in Excel for Mac

Steven ParkerSteven Parker Nov 20, 2026 869 views

Question details

The user needs the PivotChart to update when a slicer filters its related PivotTable.

Fix a PivotChart That Does Not Update After a Slicer Selection in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A slicer is used to filter a PivotTable and its related PivotChart.
Observed behavior
The PivotTable responds to the slicer, but the PivotChart does not visibly update until the worksheet zoom changes.
Before you start

Open the affected workbook and confirm that the PivotTable changes when you select a slicer item. Note the PivotChart type and check your Excel version under Excel > About Excel.

Solution 1Recommended

Update Excel and macOS, then restart your Mac

Use this approach first to rule out an outdated Excel version or add-in.

The original guidance recommends Excel version 16.14.1 or later and notes that some newer chart types may require version 16.15 or later. Install the latest updates available for your Mac rather than relying on these older minimum versions.

1
Check the Excel version

In Excel, select Excel > About Excel and note the version number.

2
Update Office

Select Help > Check for Updates and install the available Office updates. If Excel came from the Mac App Store, check the App Store's Updates section instead.

3
Update macOS

Open System Settings > General > Software Update, or System Preferences > Software Update on older macOS versions, and install available updates.

4
Check add-ins and restart

Update any installed Excel add-ins using their provider's instructions, restart your Mac, and reopen the workbook. Select a slicer item to test the chart.

Update Excel and macOS, then restart your Mac
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to open existing workbooks. It does not repair Excel's PivotChart display issue, so check complex charts and slicers after opening a workbook.

Open and edit common Microsoft Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface to work with existing data.Review PivotTable-based workbooks while checking chart and slicer compatibility.Move between office tasks in a lightweight, free suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the PivotChart update when I change the zoom?

Changing the zoom can force the worksheet to redraw. If the PivotTable has already filtered, the chart may be showing a stale display rather than reflecting the current result. Test again after updating Excel.

Where can I find my Excel version on a Mac?

Open Excel and select Excel > About Excel. The version number appears in the information window.

How can I tell whether the problem is specific to one workbook?

Create a new workbook with sample data, then insert a PivotTable, PivotChart, and slicer. If the new chart updates normally, investigate the chart type and setup in the original workbook.

Does the PivotChart type matter?

It can. The original guidance notes that some newer chart types may require Excel for Mac version 16.15 or later. Check the chart type and install the latest Office updates available for your Mac.