Copy Chart without links

[Chuck Cronan]

I wrote a nice macro to record data from an instrument and view a chart of it in real time. I want the operator to copy the spreadsheet/chart (all on the same worksheet) to another workbook. The chart links back to the original worksheet referencing all the data on that sheet and NOT on the new sheet.

Can I write a macro to make that transfer (without back linkage) or is it possible to that some other way with some ease?

Thanks.

 

[PaddyD]

hi - welcome to the board!

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

...should contain all you need to know, and more, on the subject.