G Guest May 16, 2006 #1 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
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
D Debra Dalgleish May 16, 2006 #2 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.
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.
