Change source data of a pivot chart

M

MRIreland

In Excel 2007 can you change the source data of a pivot chart I have multiple
charts and tables which I want to copy but the copied charts still refer to
the original pivot table
 
J

Jon Peltier

I have limited practice with this, but I think if you copy the sheet with
the pivot table and chart to a new workbook, the links travel with the
copied pivot table, not the original. You can then move the sheet into the
original workbook.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change source data in a pivot chart 4
Odd Excel 2007 behavior: copied chart linked to source sheet 4
refreshing charts 3
How do i export a pivot chart as a static chart object? 2
charts and pivot tables 2
Formatting pivot chart axis labels for dates 10
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Cannot change data source for copied charts 1

Top