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?
Pasting Excel Charts as Enhanced Metafiles
5 posts
• Page 1 of 1
- 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
Next
Pasting Excel Charts as Enhanced Metafiles
by Donahue » Wed, 01 Sep 2004 02:56:17 GMT
Re: Pasting Excel Charts as Enhanced Metafiles
by 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
by 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
by 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
by 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)
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 37 guest