Did you also look at the possibility of sizing the image to x units. As it
seems you are using stacked columns it would be possible to have an
additional series of up to x units (one fixed size image), slotted into the
most appropriate series order, with similar value (x) deducted from an
adjacent series.

Otherwise you could do pretty much as you ask, ie place your respective
images over columns, perhaps all at same height in a row or to vertical
centers of the columns (bit more work). The tedious bit is working our the
'inner' coordinates of the plot area (ticklabels are in the 'outer').

Hopefully though one of Jon's method will have worked for you.

Regards,
Peter T


"Trevor Williams" wrote in
message ...
The difference should be obvious, but as you asked... If you fill the
series
with an image the image becomes the series, and stretches , or stacks in
the
series (creating more than one image). If you position a floating image
over
the series the image remains the original size, shows only as one image,
can
be controlled easier using VB, and the series below the image remains in
the
format applied.

Thanks for trying.

Trevor



"Joel" wrote:

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