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