View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Barlow Tim Barlow is offline
external usenet poster
 
Posts: 34
Default PlotArea picture from wbk?

Charley,

Stephen Bullen produced a procedure for converting pictures stored in the
workbook into bitmaps:

"Creates a standard Picture object from whatever is on the clipboard.
This object can then be assigned to (for example) an Image control
on a userform. The PastePicture function takes an optional argument of
the picture type - xlBitmap or xlPicture."

I've used his code previously to capture pictures from a workbook and place
them on a userform. It might work for a chart.

Check out Stephen's website at
http://www.bmsltd.co.uk/Excel/Default.htm

and scroll down until you find PastePicture.

HTH

Tim

"Charley Kyd" wrote in message
...
The only method I can see for adding a picture to a plot area is...
ActiveChart.PlotArea.Fill.UserPicture
...which has a PictureFile argument that looks to a saved picture file.

Is there a way to programatically add a picture to the plot area using a
bitmap saved in the workbook?

Thanks.

Charley