View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jeff in GA Jeff in GA is offline
external usenet poster
 
Posts: 23
Default Some charts won't copy properly from Excel 2007

Jon, I do appreciate you pointing that out, but it does not solve this problem.

It does answer a different question I posted here, as I used that feature in
the Excel 2003 (the hiddent shift-copy as feature), so I'm glad you pointed
that out to me.

HOWEVER, I just tried it and it did not work. I am convinced this is a bug
in Excel 2007. Here's why: if I open the xls in Excel 2003, I can copy and
paste the image perfectly well (that is how I've been doing it since it
doesn't work from 2007). Again, it is not all the charts in this file, it is
only 2 of many that won't copy. What it does is paste the chart box without
any of the Y or X axis data (if I paste into Corel Draw). And it won't paste
into a Word doc file at all as a metafile! And if I paste it into CorelDraw
as an enhance metafile, it forces Corel to close. I don't have that problem
pasting the exact same chart from 2003. So, until MS fixes this, I need to
keep Excel 2003 installed on one PC in order to export the charts.

Please let me know when/if any other solutions appear.

"Jon Peltier" wrote:

Regular copy? Try copying as a picture. On the Home tab, go to Paste As
Picture Copy As Picture. Cleverly hidden, eh? I didn't even know it was
there for a couple months.