Datestamp & Paste Chart resolution

  • Thread starter Thread starter SteveG
  • Start date Start date
S

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
 
2) Can the image resolution be adjusted with a registry entry like
"ExportBitmapResolution" for PowerPoint?
Click to expand...

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