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 into Word
Whenever I paste Excel charts into Word, the fonts end up looking terrible.
Is there an easy solution? Pasting as a picture does not work. The only thing that does work is right clicking on the chart while in Word, selecting "Edit Picture", then fixing the text that has changed position and direction. But then my chart is no longer a simple picture. Help! |
#2
|
|||
|
|||
Pasting Excel charts into Word
How are you pasting it?
I have no problem using the Word Insert Object command. 1 - In Excel, have the chart saved in its own separate .xls file, no other worksheets. 2 - In Word, choose InsertObject. 3 - Click on the Create from File tab and browse to the .xls file. (Choose Link to file if you'll be making changes to the chart and you want them transferred every time you open the Word doc.) 4 - Okay, voila, chart's in there looking fine. You can adjust the overall size of the chart-object if it's too big for the Word page. Does that help? |
#3
|
|||
|
|||
Pasting Excel charts into Word
While the chart is still in Excel, format it exactly as it must appear in
Word. Make it the correct size, so it does not need to be resized in Word. Then select the chart, hold Shift while selecting the Edit menu, and choose Copy Picture (Shift changes Copy to Copy Picture). Choose the On Screen and Picture (not Bitmap) options. Then go to Word and paste normally. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Theresa" wrote in message ... Whenever I paste Excel charts into Word, the fonts end up looking terrible. Is there an easy solution? Pasting as a picture does not work. The only thing that does work is right clicking on the chart while in Word, selecting "Edit Picture", then fixing the text that has changed position and direction. But then my chart is no longer a simple picture. Help! |
#4
|
|||
|
|||
Pasting Excel charts into Word
Thank you!! This fixed the problem. When copying the picture from Excel I
would right click on the picture and copy, then when I pasted it into Word my only options were to paste as an Enhanced Metafile or an Excel Chart Object. The method you describe allows me to paste the chart as a Windows Metafile, which must be the fix. Also, the shift + Edit / Copy Picture method allows me more options (i.e., as shown on screen or as shown when printed). I can't tell you how grateful I am!! "Jon Peltier" wrote: While the chart is still in Excel, format it exactly as it must appear in Word. Make it the correct size, so it does not need to be resized in Word. Then select the chart, hold Shift while selecting the Edit menu, and choose Copy Picture (Shift changes Copy to Copy Picture). Choose the On Screen and Picture (not Bitmap) options. Then go to Word and paste normally. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Theresa" wrote in message ... Whenever I paste Excel charts into Word, the fonts end up looking terrible. Is there an easy solution? Pasting as a picture does not work. The only thing that does work is right clicking on the chart while in Word, selecting "Edit Picture", then fixing the text that has changed position and direction. But then my chart is no longer a simple picture. Help! |
#5
|
|||
|
|||
Pasting Excel charts into Word
Thanks for trying, but your method did not work for me. I couldn't get the
chart to look exactly as it was formatted when I inserted it as an object, plus I have multiple charts in the same worksheet, and don't want a separate file for each chart. I appreciate your help, though. I was right clicking and pasting special, as Enhanced Metafile. I guess that was the proble. I should have been pasting as Windows Metafile. The only way to do that is by holding shift + Edit, then selecting Copy Picture. See post following yours (from Jon Peltier) for full description. It works perfectly! "chowgirl" wrote: How are you pasting it? I have no problem using the Word Insert Object command. 1 - In Excel, have the chart saved in its own separate .xls file, no other worksheets. 2 - In Word, choose InsertObject. 3 - Click on the Create from File tab and browse to the .xls file. (Choose Link to file if you'll be making changes to the chart and you want them transferred every time you open the Word doc.) 4 - Okay, voila, chart's in there looking fine. You can adjust the overall size of the chart-object if it's too big for the Word page. Does that help? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
take yet another lesson from wordperfect "reveal codes" | wordperfect is superior | General Discussion | 5 | May 11th, 2009 07:58 PM |
Print Excel charts in Word 2003 with fixed size | Phil | Charts and Charting | 1 | November 3rd, 2005 04:24 AM |
How do I create a Word form like corel WP merge documents? | dlee_at_mmsgov | General Discussion | 2 | October 8th, 2005 06:29 AM |
Envelope Address | GR | New Users | 5 | April 24th, 2005 09:48 PM |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |