Pasting Excel Charts as Enhanced Metafiles



  • 1. Pivot Tables drag & drop
    Sometimes when I attempt to create my Pivot Tables in 2007 it will not let me drag and drop my data in the new sheet. It won't show the small icon for columns or rows. I have to drag it to the box on the bottom right(row labels, column labels...etc). Don't know how to do the VALUES. But my problem is the drag and drop and icon displaying. I only see this problem in some 2007 spreadsheets when I create the new Pivot Table. Don't know if I'm doing something wrong. Is this a know problem that can easily be resolved? How can I fix this problem? Thanks, Ty
  • 2. Highlight Data Points that change in Graph
    Hi all Is it possible to highlight data points that change slope in Excel 2003 and if so how. Richard
  • 3. Displaying Cell Comments in Chart Points Q
    Is it possible to show cell comments within the data points within an Excel Graph?
  • 4. Forcing A Line To Be Truly Horiz. How, Please ?
    On 25 Juni, 17:47, Bob < XXXX@XXXXX.COM > wrote: > Hello, > > Using Excel 2007 > > Using a straight line with an arrow head in my graph/chart. > > At first, the line come out perfectly horiz., which is what I want. > > But playing with it afterwards, e.g., changing the length of,it is no > longer horiz. > > It is either a fair number of degrees above horiz., or below. > > Is there some key to press to "force" it to be horiz. >> >> Thanks, >> Bob Push the SHIFT key, both when you originally create the line and when you "play with its length" later. Hope this helps / Lars-e

Pasting Excel Charts as Enhanced Metafiles

Postby Donahue » Wed, 01 Sep 2004 02:56:17 GMT

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?

Re: Pasting Excel Charts as Enhanced Metafiles

Postby Jon Peltier » Wed, 01 Sep 2004 12:57:14 GMT

What if you copy the chart as a picture in Excel? Hold shift while 
selecting Copy Picture from the Edit menu, then use the On Screen and 
Picture (not Bitmap) options.

Otherwise, it sounds like something fishy with your template.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Re: Pasting Excel Charts as Enhanced Metafiles

Postby Donahue » Sun, 05 Sep 2004 04:45:57 GMT

Thanks, Jon.

Our designer's on paternity leave but we're hoping to have 
him redo the template when he returns. Meanwhile, we'll 
try your suggestion and post back with results.

shift while 
On Screen and 


Re: Pasting Excel Charts as Enhanced Metafiles

Postby anonymous » Thu, 09 Sep 2004 21:53:13 GMT

I've just tried copying the excel chart as a picture (not 
bitmap).  But when I Paste Special as a metafile I still 
have the same problem.

Any other suggestions?


Re: Pasting Excel Charts as Enhanced Metafiles

Postby Jon Peltier » Fri, 10 Sep 2004 07:50:20 GMT

If you copy it as a picture (not bitmap), all you have to do in Word is 
Paste, not Paste Special. See if that helps.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Similar Threads:

1.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.

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

To tailor all our charts we past/special/metafile line charts into 
Powerpoint, then ungroup twice to be able to move/chop/change elements of the 
chart. When I ungroup the second time the line (representing data) actually 
breaks into a huge number of invidual lines (according to the underlying 
source data), as opposed to one single line. As a result, things are much 
more tedious/complicated. Any way to ungroup a chart in Powerpoint and have 
the line stay as a line, and not a ton of individual lines?

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

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?

4.Pasting excel as enhanced metafile

I usualy paste tables using from excel in to PP presentations as an enhanced 
metafile but recently these pictures are being pasted witha green boundary 
for no apparent reason. Any ideas ?

5.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! 

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

7. Pasting from xl into word as an enhanced metafile

8. copying all charts as enhanced metafiles

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 37 guest