Embedding pictures on data points of a chart

[syam1919@gmail.com]

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.

[Andy Pope]

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


syam1919@gmail.com wrote:
> 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.
>

--

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