Copy Excel Chart from one book to other without links...

[venkith]

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

[Jon Peltier]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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

[cte67w]

How does one copy a chart from one Excel book to another? Book, not worksheet ... a different .xls file.

[Palmetto]

How does one copy a chart from one Excel book to another? Book, not worksheet ... a different .xls file.

You should start a new thread with your own question and include a link to this post rather than hijaack another thread.

Your question is already answered in this thread and two methods are described. What more do you need to know?