How do you update a pivot chart when the data is changed?

[Guest]

When I change/edit the source data in my Pivot Table and then refresh the
pivot table, the new data is displayed. However, when I click on the drop
down arrown of one of my fields in the pivot table, the old data (along with
the new data) is still being displayed. How can I delete the old data from
the drop down box?

 

[Debra Dalgleish]

To clear old items from the pivot table, you can use one of the
techniques shown here:

http://www.contextures.com/xlPivot04.html