View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default xl2002: Position Picture in SeriesCollection

What is the difference??????????
Try clicking the BAR - Format Data Point - Fill Effect - Picture - Select
Picture.

I went looking for the shape of the Bar to try to get the Top and Left
poistion but could not find the object.

"Trevor Williams" wrote:

Hi Joel - thanks for the quick response.
Unfortunately I don't need to 'fill' the series with a picture.

All I need to do is place the picture in the center of the series. (floating
over the top of the series rather than embedded)

Any ideas?

Trevor

"Joel" wrote:

Does this code help. You don't need to position the picture, the bars have
fill effects which alow pictures to be inserted into the chart

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 10/19/2007 by Joel
'
'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(2).Select
Selection.Fill.UserPicture PictureFile:= _
"H:\My Documents\My Pictures\abc.jpg", PictureFormat:=xlStretch, _
PicturePlacement:=xlAllFaces
Selection.Fill.Visible = True

End Sub

"Trevor Williams" wrote:

I have a stacked column chart containing several series. I need to position
a different pre-defined image in the center of each series that appears in
the charts.

All images are the same size and small enough to fit into the series, each
image already exists on the sheet, and each image name is sequential (for
series 1 the image name will be "Pic1".)

Any ideas gratefully received.

Trevor Williams