Hi,

Jon Peltier explains various way including the picture method.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

rmellison wrote:
Is there a way of copyiong a chart from one workbook to another and
'unlinking' it, such that it does not update from the original worksheet if
the original data is changed. Does it need to be copied as a picture or
similar??

Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info