.ChartArea.Fill.UserPicture PictureFile:="how to reference an obj.

[Guest]

How do you reference an object from the clipboard to use as a background
picture for the Excel Chart Area instead of an actual file. I'm trying to
avoid an actual file and so I've placed the picture in the file with my Excel
macro. Copy & paste does not work. Thanks.

 

[Stephen Bullen]

Hi Carlos,

How do you reference an object from the clipboard to use as a background
picture for the Excel Chart Area instead of an actual file. I'm trying to
avoid an actual file and so I've placed the picture in the file with my Excel
macro. Copy & paste does not work. Thanks.

I don't see a property that we can use to set the picture directly (i.e. not
from a file), so I think the best we can do is to use the PastePicture routine
on my web site to save the picture as a file, set the chart to use the file,
then delete the file.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk