Copying chart not refering it..

[ritu]

Hi i am trying to move a chart in to a different workbook. now by doing
this the chart i get in the new workbook is the reference to my
previous workbook. so any chages in the table is reflected in both the
charts. Which i dont want. i just want it to reflect in the current
worksheet and not in the new workbook.

can someone suggest what shud i do..

[Jon Peltier]

Copy the worksheet that the chart is embedded in, so the chart points to the
copied sheet. Then use paste special to paste the new values or formulas
onto the copied sheet.

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

"ritu" <rutumadesai@gmail.com> wrote in message
news:1146517131.443372.226810@i39g2000cwa.googlegroups.com...
> Hi i am trying to move a chart in to a different workbook. now by doing
> this the chart i get in the new workbook is the reference to my
> previous workbook. so any chages in the table is reflected in both the
> charts. Which i dont want. i just want it to reflect in the current
> worksheet and not in the new workbook.
>
> can someone suggest what shud i do..
>

[AA2e72E]

Right Click on the Chart, select the Source Data Option and change the Data
Range and Series to point to your open workbook instead of where you copied
the chart from.