Pulling Excel charts and graphs into Powerpoint or Word is a nightmare

[littleearthquakes]

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

 

[Frank Kabel]

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

 

[KR]

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.

 

[Kurt Dupont]

Maybe you should take a look at www.take-off.as/datapoint to automate this
kurt

 

[Courtney]

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