Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linking charts
Hi, I'm wondering if I can have a chart on one workbook page linked to a
chart on another workbook page (it will be the same chart derived from the same source data), and when I refresh the data, both charts will update. Here's why: I have the data and 1st version of chart in a "working" section of the workbook. Then I have a "report" view of the chart that need to be a certain size- this is the 2nd copy of the working graph. Currently I've been copying and pasting the "working" chart into the "report" chartbut that is kind of a pain. I appreciate your suggestions! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linking charts
Hi,
Select the first chart and copy it, move to the other sheet and choose Paste. Both charts are linked to the same data source, not one chart to the other. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Stephanie" wrote: Hi, I'm wondering if I can have a chart on one workbook page linked to a chart on another workbook page (it will be the same chart derived from the same source data), and when I refresh the data, both charts will update. Here's why: I have the data and 1st version of chart in a "working" section of the workbook. Then I have a "report" view of the chart that need to be a certain size- this is the 2nd copy of the working graph. Currently I've been copying and pasting the "working" chart into the "report" chartbut that is kind of a pain. I appreciate your suggestions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking charts to one database | Charts and Charting in Excel | |||
Linking two identical charts | Charts and Charting in Excel | |||
Linking Charts | Charts and Charting in Excel | |||
linking of outside charts to each cell in the sheet | Charts and Charting in Excel | |||
Linking Charts | Charts and Charting in Excel |