Can a chart reference the local page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a weekly page of data, with charts on that page that reference that
data. Each week I copy the page and rename it for the new week, but the
charts (and pivot table) keep pointing back to the old week. How can I set
up the charts to reference the data on the same page as the chart?
 
Copy the whole sheet, with the embedded chart on it. Copy the new data, and
paste it in place in the copied sheet.

- Jon
 
That was pretty close. Turns out, I was copying by ctrl-A, ctrl-C, ctrl-V,
and that doesn't work, but right click on the page tab and click Copy/Move
references the chart to the local page, even after I change the page name.
But it doesn't work for the pivot table. Any ideas for that?
Mike H.
 
You have to click in the pivot table, run the wizard, go back, and change
the source data range of the pivot table.

- Jon
 
Back
Top