View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default copy paste problems for chart from excel to power point, solution

Does the chart have to remain linked to Excel?

If not, copy the chart as a picture. In Excel, select the chart, hold Shift
while selecting the Edit menu, choose Copy Picture; in most cases, the On
Screen and Picture options provide the best results.

If so, make a copy of the chart, change its location to a chart sheet, move
the chart sheet to a new workbook. Go to Page Setup and adjust the margins
so the chart within the margins is the size you need in PowerPoint; e.g., a
chart that has to be 3.5 by 5 on a 8.5 by 11 page needs margins of
(8.5-3.5)/2 or 2.5 top and bottom and (11-5)/2 or 3 left and right. Copy
this chart and paste it into PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jean" wrote in message
...
I am really having troubles copying excel charts to power point, the charts
are getting messed up after copying and pasting to power point. I tried
everyting, turned off auto scale and selected the don't move or resize
with
cells option and still having the same problem, any idea how to fix that?
Thanks!