If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Maximum number of data points for an xy scatter chart? | Rich F | Charts and Charting | 7 | July 11th, 2007 03:06 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Fan charts | Dean | Charts and Charting | 7 | May 30th, 2005 11:51 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |