Updating Pivot Charts
If the data of the source sheet has been changed, you must refresh the pivot table and the pivot chart is updated accordingly. To refresh the pivot table (and thus the pivot chart):
-
Choose Data - Pivot Table - Refresh.
-
Choose Refresh... in the context menu of any cell in the pivot table.