Embedding pictures on data points of a chart

Hi,

Im trying to embedded the pictures on data points of a chart through
VBA using following code.

ActiveChart.SeriesCollection(1).Points(4).DataLabe l.Fill.UserPicture
PictureFile:="C:\Syam\PptPics\Picture4.jpg" ',
PictureFormat:=xlStackScale, PictureStackUnit:=4 ,
PicturePlacement:=xlAllFaces

But im facing error.
If if using the code after removing the
******************
PictureFormat:=xlStackScale, PictureStackUnit:=4 ,
PicturePlacement:=xlAllFaces
*****************

in the abovecode then the picture can be imported with out any error.

Can anybody tell me how to proceed this.

Hi,

It would appear you are trying to use the picture stack option that is
applicable to column and bar charts on a data label. You can not do
this. You can apply a picture to the data labels background but the
other parameters and invalid.

Cheers
Andy


wrote:
Hi,

Im trying to embedded the pictures on data points of a chart through
VBA using following code.

ActiveChart.SeriesCollection(1).Points(4).DataLabe l.Fill.UserPicture
PictureFile:="C:\Syam\PptPics\Picture4.jpg" ',
PictureFormat:=xlStackScale, PictureStackUnit:=4 ,
PicturePlacement:=xlAllFaces

But im facing error.
If if using the code after removing the
******************
PictureFormat:=xlStackScale, PictureStackUnit:=4 ,
PicturePlacement:=xlAllFaces
*****************

in the abovecode then the picture can be imported with out any error.

Can anybody tell me how to proceed this.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info