Sandy -
Why paste it as a bitmap? If it is displayed at anything but the
resolution of the chart in Excel, it will look horrible. You will have
better results pasting it as a picture, which means metafile. This will
not suffer from distortion if it has to be resized. Even better if you
copy it in Excel as a picture, by holding Shift while clicking on the
Edit menu. Copy becomes Copy Picture. Use the On Screen and As Picture
options.
For more info:
http://peltiertech.com/Excel/XL_PPT.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Sandy wrote:
I am trying to copy an Excel graph to PowerPoint as a Bitmap.
PowerPoint does not seem to support paste as bitmap via a macro. Excel does
not seem to support copying a graph as a bitmap (it does support coping
worksheet data as a bitmap using the syntax "Selection.CopyPicture xlScreen,
xlBitmap").
How can I copy a graph worksheet from Excel to PowerPoint via VB code?
Thank you.
Sandy