Datestamp & Paste Chart resolution

[SteveG]

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

 

[Jon Peltier]

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

 

[Del Cotter]

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.