Pasting Excel Charts as Enhanced Metafiles

MS EXCEL

    Next

  • 1. X error bar
    Hello, I can find in Format Data Series the 'Y Error Bar' but nowhere can I fnd the 'X Error Bar'. How can I get this one? Office 2000. Thank you
  • 2. Automatic Charting Problems
    Hello, Please bare with me as I try to explain my report & problem. I have a report, that has several rows of values that need to be charted out. To avoid the hassle & headache of having one million charts to see, I have set up a look up table which the user can select up to 5 rows of values to chart out on one chart. In order for this to work, my chart has to be set on those 5 lookup rows. But incases where the user will only want to chart out one row, the chart still is showing the other rows that do not have information in them. Now assuming I havn't lost you yet, are they any kind of tricks that I can do with charts, so that it will not show empty series even though it is included? If it's easier, I can send out the actual file to anyone who feel they'd be able to help me, or suggest other ways around this problem. Thank you, Jay Gustafson
  • 3. have larger paper size on page setup?
    We create Excel Spread sheets with Engr data. These are linked into CADD drawings. The spreadsheet could be 22" x 30". When we link the document, it only displayes what the page setup it set to, so we need to re-link the document up to 6 times to display all the data. Tried changing the plot area as well. Anybody know if larger paper sizes like "D" size or 24" x 36" are doable? Thanks

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

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
 http://www.**--****.com/ 
_______






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

template.
only 
show 
BUT 
template.
did 
into 
2003 
on 

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?

have 


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
 http://www.**--****.com/ 
_______







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

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?
-- 
Ben

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)"

Hello

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)

OR

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 45 guest