View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Chart won't refresh!

Make sure all the new data is included in the pivot table source. There
are instructions here for creating a dynamic data source for the pivot
table:

http://www.contextures.com/xlPivot01.html#Dynamic

srpd wrote:
After creating Pivot tables and charts, I added more data to the master
sheet. Then selected a cell in a pivot table and hit Refresh. The screen
bounced a little as the cell sizes changed but the data remained the same.
What am I doing wrong?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com