Pasting Excel Graphs (charts/enhanced metafile pictures) into Word



  • 1. Additional Testing
    I spent 2 hours on the phone with Adobe Acrobat support. They had me try every possible option under the sun and we were not able to resolve this issue. While on the phone, I realize that the PNG renders poor only if the graphic has transparency enabled. I asked the support technician to raise the ticket. He put me on hold and returned to say that it was raised, but they declared it a "bug" and suggested I upgrade to Acrobat 9. I did, but it has the same issue.
  • 2. How do you set the default formatting of inserted pictures?
    I'd like all my inserted pictuers to have a blue border. Can I make that a default?
  • 3. Excel Graph in Word printing larger than it looks in print preview
    I have reports which I produce in MS Word with embedded bar charts. When I am updating a report with new information, I change the data in the Excel worksheet that defines the chart, and then when I return to editing in Word, everything looks fine on the screen. However, when I print - whether to an Adobe PDF document or directly to a printer, the information in the charts is blown up to about 125% of original size. Since the chart box prints in the original size, the content does not all show. How do I fix this?
  • 4. Excel graph refreshes too much
    I have many excel graphs included in a word document. Some excel graphs include lots of data. Everytime I move my mouse or try to type when this type of graph is on the screen, the graph has to refresh again and again and it's really annoying. Can I turn off graphic refresh or can I increase memory availability to solve this problem? Any help is appreciated.
  • 5. Picture shearing in Word 2003
    I want to make a picture that I have inserted from a rectangle into a parallelogram bounding picture, but I can't find any useful button/options to do that. Is this even supported? If so, where would I find this functionality?

Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

Postby Lorraine » Wed, 25 Aug 2004 06:38:01 GMT

I am looking for a similar solution posted by Donahue, 
8/20/04, 7:07 am.

I have pasted excel charts and enhanced metafile pictures 
in a word document, sent this to a colleague who has Word 
2001 for the Mac, and she is unable to view these files.  
She sees a big (red?) X.

Size/memory is not an issue here.

Any help here?

Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

Postby Lorraine » Wed, 25 Aug 2004 06:49:29 GMT

I neglected to mention that I have Word 2003 (Windows 
XP).  THis is what I use to paste excel graphs into word 
documents, and these images are not viewable in Word 2001 
(for the Mac).



RE: Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

Postby QW5uaWU » Tue, 09 Nov 2004 09:25:03 GMT

You might like to look at  http://www.**--****.com/ 

I have the same problem. At home I have a Mac running Office v.X and at work 
I am using Word 2000. The problem works both ways. I "paste special" my Excel 
graphs at home as "picture" and the document has the red X problem on my PC 
at work and vice versa. The odd thing is that not all of the graphs 
disappear. Some remain intact. 

Similar Threads:

1.Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile)


I am copying a section of an Excel Spreadsheet, and then pasting into
word using Paste Special -> Picture (Enhanced Metafile)

When I right click on the object in word, one of the menu choices is
"Edit Picture" This will allow me to change text in the picture, which
seems to be included through the use of text boxes.  I make a minor
change that is required, but then I cannot seem to revert the image or
picture back to its previous form, which seems to be as a normal
picture file that has been inserted.  The only way I can figure out
how to do this is by using the undo command, but I loose my text
chance.  If the picture stays in the new, editable format, whenever I
click into it, all of the text is becomes highlighted, which really
slows down my ability to continue work on the rest of the document.
The new format seems to be seen by word as a Drawing Canvas.

Does anyone know how I can make a text change, and then get Word to
see the image as an inserted picture file again as opposed to this
drawing canvas?


2.Pasting Excel cells as "Picture (Enhanced Metafile)"


I need to paste cells from Excel into Word  as "Picture (Enhanced Metafile)" 
(I need to do this over 100 times).  Every time I do this, the resulting 
picture's top left corner ends up violating the top left margin of the Word 
document (even though my cursor was located at the top left corner of the 
page when I did the pasting).  I then have to both move and resize this 
picture.  Is there any way to either

a)  automatically resize the picture so it has the largest possible size 
without violating any of the page margins (and not being distorted)


b)  if (a) above is not possible, at least move the picture so that its top 
left corner is at the top left corner (as defined by the margins set for the 
page) of the page?

Thank you for your help! 

3.Paste Special , Paste link as Picture (enhanced metafile)


One of my colleague wants to paste excel table  in word.

He select the cell and use paste special in Word , paste link and would like 
to  paste as Picture(Enhanced Metafile).

But Picture(Enhanced Metafile option is missing in word.  He only gets 
Graphic (windows metafile)

We are using Office 2003. He told this option was avalaible in Office XP 2002.

Any idea, how to get this option in Word 2003?


4.Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile

When using copy/paste special to take a range from Excel 2002 to Powerpoint
2002 all is fine on my PCs - i.e. all formats are kept as expected.

However, my client has 2 of his own machines and 2 of his clients that lose
the font colour only - all text is black (background colours etc are fine).
Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced

Anyone else had this problem?  If so, any solutions please.

5.Pasting Excel Charts as Enhanced Metafiles

Since upgrading to Office 2003, I am unable to 
successfully paste Graphs made in Excel as enhanced 
metafiles into my office's Microsoft Word report template.

When I paste special, as an enhanced metafile, I am only 
able to see the very bottom piece of the graph.  I can 
move the graph around and resize it, but it will not show 
up on screen.  Nor does it show up in print preview.  BUT 
it comes out just fine when I print a hard copy.

This issue is unique to our report template, as I can 
paste Excel graphs into a blank Word document with no 

But it is also unique to Excel, as I can successfully 
paste graphs made in Power Point into our report template.

I've tried re-creating the template in 2003 but that did 
not help.  I've also tried every combination of Office 
2000 and 2003 pastes (i.e. graphs made in Excel 2003 into 
the 2000 template, graphs made in Excel 2000 into the 2003 
template, etc).  Nothing seems to work.

Has anyone seen this problem before?  Any suggestions on 
how to get aorund it?

6. Excel 2007 line-chart pasted as an enhanced metafile - editing

7. Macro to paste chart as enhanced metafile

8. Paste Special, picture (enhanced metafile) Problem in Word 2003

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 96 guest