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
|
|||
|
|||
Pulling Excel charts and graphs into Powerpoint or Word is a nightmare
Is it just me, or does it totally suck trying to work with excel files
within ppt. Copy and paste in (even as a ppt table), they come in all garbled and it's impossible to clean it up. Import them in and same prob. Try to make changes to it once it's in ppt and once you click out of the the excel graph it show sup all distorted. Am I the only one who dreads working with excel files in ppt? For that matter, I have the same issues pulling excel into MSWord. Anyone have any suggestions on how to MASTER this skill? Thanks, J |
#2
|
|||
|
|||
Hi
I know this problem. My workaround is to insert the chart as image ('Edit - Paste Special'). Though i loose the ability to link the chart to the source file at least I can control the 'look' of the pasted image -- Regards Frank Kabel Frankfurt, Germany "littleearthquakes" schrieb im Newsbeitrag om... Is it just me, or does it totally suck trying to work with excel files within ppt. Copy and paste in (even as a ppt table), they come in all garbled and it's impossible to clean it up. Import them in and same prob. Try to make changes to it once it's in ppt and once you click out of the the excel graph it show sup all distorted. Am I the only one who dreads working with excel files in ppt? For that matter, I have the same issues pulling excel into MSWord. Anyone have any suggestions on how to MASTER this skill? Thanks, J |
#3
|
|||
|
|||
Also try holding down the shift key, then mouseclick the edit menu in Excel
and you get an extra option "copy as picture", which I've found helpful as well (sometimes even 'paste special' messes up a direct transfer). You can copy as shown or as printed, depending on whether you want the background grid lines, etc. As with Frank's solution, you cannot edit the chart or range once it is pasted in. "Frank Kabel" wrote in message ... Hi I know this problem. My workaround is to insert the chart as image ('Edit - Paste Special'). Though i loose the ability to link the chart to the source file at least I can control the 'look' of the pasted image -- Regards Frank Kabel Frankfurt, Germany "littleearthquakes" schrieb im Newsbeitrag om... Is it just me, or does it totally suck trying to work with excel files within ppt. Copy and paste in (even as a ppt table), they come in all garbled and it's impossible to clean it up. Import them in and same prob. Try to make changes to it once it's in ppt and once you click out of the the excel graph it show sup all distorted. Am I the only one who dreads working with excel files in ppt? For that matter, I have the same issues pulling excel into MSWord. Anyone have any suggestions on how to MASTER this skill? Thanks, J |
#4
|
|||
|
|||
littleearthquakes wrote:
Is it just me, or does it totally suck trying to work with excel files within ppt. Copy and paste in (even as a ppt table), they come in all garbled and it's impossible to clean it up. Import them in and same prob. Try to make changes to it once it's in ppt and once you click out of the the excel graph it show sup all distorted. Am I the only one who dreads working with excel files in ppt? For that matter, I have the same issues pulling excel into MSWord. Anyone have any suggestions on how to MASTER this skill? Thanks, J Wow. I find it incredibly easy. In fact, I create all my charts in Excel, then place them in Powerpoint slides (provided you installed Microsoft Chart--it installes automatically with Excel). Select the chart page (not the chart itself) in Excel, press Control-A, Control-C. Go to your Word or Powerpoint document and press Control-V. Your chart will appear with resizing tabs. If you right-click on the chart, you will find that the spreadsheet (and any formulas) comes with the chart. Works perfectly. courtney sends.... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Several Charts to a PowerPoint Presentation | JRPK | Links and Linking | 3 | April 2nd, 2005 10:02 PM |
Pulling Excel charts and graphs into Powerpoint is a nightmare | littleearthquakes | Powerpoint | 1 | October 17th, 2004 04:13 AM |
How do I export an excel workbook out of a powerpoint presentatio. | utstudent | Powerpoint | 1 | October 16th, 2004 03:51 PM |
Pasting Excel Charts as Enhanced Metafiles | Donahue | Charts and Charting | 4 | September 8th, 2004 11:50 PM |
Problem sizing charts and graphs | J Newell | Powerpoint | 6 | August 27th, 2004 02:26 AM |