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.

Embedding pictures on data points of a chart
 

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