Forum Discussion
Excel Data Model Pivot Charts do not update on Refresh All
I tested the workaround suggested by SergeiBaklan and this did work for me. It appears Pivot Charts, without a Pivot Table, using data directly from the data model have a visual bug with refreshing. The way around it is to rebuild the chart with a pivot table as I don't believe there's anyway to attach a pivot table to a pivot chart after the fact.
Although there's a workaround I still believe this is a visual bug. To emphasise this I rebuilt the workbook showing the issue (attached).
Two charts from the data model, with the exact same settings except one has a pivot table associated with it. Changing the source data and pressing Refresh All causes only the bottom chart to visually update:
Closing and reopening the workbook, modifying a filter or ticking defer layout update and then pressing update will all cause the top chart to visually update and show the same as the bottom chart. This is clearly not the intended functionality.
Workaround is to build PivotTable and when connected PivotChart. Latest could be moved after that into separate sheet.
I started encountering this error in the last couple of weeks — around late August 2024. At first, I thought it was an issue with my laptop, but other colleagues using the shared workbook are experiencing the same problem. To investigate further, I created a new file with a simple table containing just 2 columns and 10 rows, added it to the data model, and then created a pivot chart. However, even with such a small dataset, the pivot chart does not refresh (although Power Pivot does).
By the way, thanks for the hint
I checked that both on Current and Beta channels on Excel 365, same story, doesn't work. But it works on Excel 2019.
Another workaround could be in re-applying the filter, that could be slicer of field filter within PivotChart, doesn't matter.
Assume we have such table added to data model and PivotChart based on it
Change it and refresh - no effect
Now apply any filter
and reset it
We have expected result.
Hope that will be fixed one day.