Embedding pictures on data points of a chart

  • Thread starter Thread starter syam1919
  • Start date Start date
S

syam1919

Hi,

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

ActiveChart.SeriesCollection(1).Points(4).DataLabel.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
 
Back
Top