If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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? |
#2
|
|||
|
|||
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://PeltierTech.com/ _______ Donahue wrote: 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? |
#3
|
|||
|
|||
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. -----Original Message----- 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://PeltierTech.com/ _______ Donahue wrote: 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? . |
#4
|
|||
|
|||
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? -----Original Message----- 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. -----Original Message----- 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://PeltierTech.com/ _______ Donahue wrote: 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? . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel creates its own hidden charts that creates a corrupt file! | FlawedLojik | General Discussions | 0 | August 29th, 2004 05:43 PM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Update Presentation with Excel charts and tables | Holly | Powerpoint | 2 | August 11th, 2004 06:03 PM |
Publishing Microsoft Excel Charts to the Web | Jim | Charts and Charting | 1 | May 15th, 2004 12:37 AM |