MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using a pivot table as the source data for a chart

Posted by Brent Williams on October 29, 2001 9:03 PM

I have several charts that are using a pivot table as their source data. To do this, I just clicked on a cell in the pivot table and then clicked on the chart wizard. The charts come out just fine. My problem comes along when new data is added to a pivot table. The charts do not update themselves with the new data. Actually some of the charts do and some don't I can't figure out what the difference between them is.

Basically I would like to know how to make a chart that will always update itself when it source data (a pivot table) is updated.


Posted by Mark W. on October 30, 2001 6:10 AM

I have the best results when I right-click a cell
in the PivotTable and choose Select | Entire Table
from the popup menu before creating the chart.