View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish
 
Posts: n/a
Default Pivot Tables and Charts

Create another pivot table, based on the first one. Then, create the
pivot chart from the second pivot table. You can hide the sheet that
contains the second pivot table.

When you change the pivot chart, only the hidden pivot table will be
affected.

amanda wrote:
Is there a way to make a table and then when i change the chart have it to
where it does not turn around and change the table



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