Copy the whole sheet, with the embedded chart on it. Copy the new data, and
paste it in place in the copied sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike H" wrote in message
...
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?