Hi Rod, What if you copy the chart to a new workbook and then break the links? (Edit- Links- Break Link)It is still a chart, but the data is then saved in the chart and not linked to source data. Good luck, Gary ----- Original Message ----- From: "Rod N Dickson" <[log in to unmask]> To: <[log in to unmask]> Sent: Friday, February 25, 2005 12:26 PM Subject: Re: Copying Charts into Different Workbooks Further to this query, The "ChartObject" has a "CopyPicture" method which can be used in place of the "Copy" method when grabbing the chart or, for that matter, any range object within the workbook. I have looked it up on Excel 2003 on a PC and the same methods are available. (My version was incorrect for Mac - I use Office 2004 on the Mac, Office 2003 and below on a PC) Regards Rod On Feb 25, 2005, at 10:56 am, Rod N Dickson wrote: I use a Mac with Office 2004 which may make a slight difference, however when I have a chart on a worksheet I can select the chart and then save the chart as a picture to the desktop, or where ever. This would bypass the word step you mention. Regards Rod On Feb 25, 2005, at 10:10 am, Fen Scott wrote: Hi guys. I wonder if anyone can help me with this:- I want to copy a number of charts from one workbook into a new workbook, but not have a link to the original workbook, so in essence want the new charts to be pictures. I can do this manually using Word as an interim step, by pasting the chart into word as a picture and then pasting into the new workbook as a picture. I am going to be doing this automatically using Excel VBA, so can anyone advise how to do this: 1) Without the interim Word step 2) Using the interim step, in Word. My knowledge of automating Word, using Excel VBA is somewhat “limited”! Many thanks in advance for your help. Best wishes, Fen Scott.