Pivot Charts Updating

Hi Donna

Thanks for your question, I have a couple of trouble shooting ideas for you so please try these steps then let me know if you're still having problems.

First of all, double check that the data you're changing in the source data actually affects the values on the second and third PivotCharts. If your charts display different data sets, eg chart 1 shows sales, chart 2 shows costs, then they will not all update in the same way.

Secondly, try making the PivotCharts again from your PivotTable. Do they behave in the way you expect (ie update when the PivotTable is refreshed)? Sometimes it can be easy to click a wrong option by mistake, but if you try again you can fix the problem. If they do refresh, then simply delete the charts that aren't working.

I hope this helps.

Kind Regards,

Sarah Reid
Excel Trainer