In order to be sure of the filename & date that a chart was produced I
have to datestamp it with a text field containing:

TEXT(NOW(),"YYYY-MMM-
DD")&MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))
+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)

I then paste an image of the chart in PPT.

This means that the chart is referenced in no matter which
presentation it is used.

1) Is there an easier way to do this?

2) Can the image resolution be adjusted with a registry entry like
"ExportBitmapResolution" for PowerPoint?

Yes this is an Excel question!

Steve

Instead of pasting the chart in bitmap format, paste as a metafile. Or copy
it as a metafile, then simply paste it. Here are a few tips:

http://peltiertech.com/Excel/XL_PPT.html

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


"SteveG" wrote in message
ups.com...
In order to be sure of the filename & date that a chart was produced I
have to datestamp it with a text field containing:

TEXT(NOW(),"YYYY-MMM-
DD")&MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))
+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)

I then paste an image of the chart in PPT.

This means that the chart is referenced in no matter which
presentation it is used.

1) Is there an easier way to do this?

2) Can the image resolution be adjusted with a registry entry like
"ExportBitmapResolution" for PowerPoint?

Yes this is an Excel question!

Steve

On Fri, 26 Oct 2007, in microsoft.public.excel.charting,
SteveG said:
2) Can the image resolution be adjusted with a registry entry like
"ExportBitmapResolution" for PowerPoint?

I think the image resolution in pixels is 120 per inch, so you can
choose the resolution of your bitmaps by setting the size of your chart
objects to the appropriate number of inches, to a maximum of about 11 or
11.5 or so inches, or a bit more than 1300 pixels.

Click on the embedded chart while pressing the shift key to select it as
an object, then set the height and width in the "Size" tab in the
"Format Object" dialogue.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.