Change source data of a pivot chart

  • Thread starter Thread starter MRIreland
  • Start date Start date
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
 
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
 
Back
Top