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