Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart reference the local page
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart reference the local page
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart reference the local page
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |