If it's an embedded chart, copy the chart's parent worksheet to the new
workbook, then paste the new data on top of the copied data.

If it's a chart sheet, move (don't copy) the chart sheet and the source data
sheet to the new workbook, then close the original workbook without saving
changes (so the saved version still contains the moved, i.e., removed,
sheets), then paste the new data on top of the copied data sheet.

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


"venkith" wrote in
message ...

Hello All,
I wanted to know if there is a way that I can copy the chart from one
workbook to other with no external link.

Say, I have a chart plotting data from Sheet 1 (A1:B100,B1:B100 of
Sheet 1) and want to copy the chart to the next sheet with data at
Sheet 2(A1:100,B1:B100 of Sheet 2)

Thanks,
Venkith


--
venkith