Fix a PivotChart That Does Not Update After a Slicer Selection in Excel for Mac
Question details
The user needs the PivotChart to update when a slicer filters its related PivotTable.

- 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.
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.
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.
In Excel, select Excel > About Excel and note the version number.
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.
Open System Settings > General > Software Update, or System Preferences > Software Update on older macOS versions, and install available updates.
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.

Isolate the PivotChart refresh behavior
Use a new chart and workbook to determine whether the issue is specific to the chart or workbook.
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.

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.




