Can a chart reference the local page

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike H" <[email protected]> wrote in message
news:[email protected]...
>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?
>

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.

"Jon Peltier" wrote:
> Copy the whole sheet, with the embedded chart on it.
> Copy the new data, and paste it in place in the copied sheet.
>
>
> "Mike H" wrote:
> > How can I set up the charts
> > to reference the data on the same page as the chart?

You have to click in the pivot table, run the wizard, go back, and change
the source data range of the pivot table.

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


"Mike H" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
> "Jon Peltier" wrote:
>> Copy the whole sheet, with the embedded chart on it.
>> Copy the new data, and paste it in place in the copied sheet.
>>
>>
>> "Mike H" wrote:
>> > How can I set up the charts
>> > to reference the data on the same page as the chart?
>