Thread: Linking charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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!