Thanks again Jon

I can't believe how easy it was to use custom series markers!

Trevor

"Jon Peltier" wrote:

ActiveChart.SeriesCollection(1).Points.Count
ActiveChart.Axes(xlCategory, xlPrimary).Width

There is some information about using shapes and VBA in Excel charts he

http://peltiertech.com/Excel/Charts/VBAdraw.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Trevor Williams" wrote in
message ...
Hi Jon

thanks for your response. I've been checking out your site for some time.
I'll give it a go.

Is there no way to work out the size of each Points with the
SeriesCollection?
Also, is there a way to obtain the length of the X axis? I need to draw a
rectangle to match it.

Thanks again.

Trevor



"Jon Peltier" wrote:

I was going to suggest this, where you keep the columns, but also include
line or XY chart series with X values calculated to position a marker in
the
middle of a column. If it is a clustered column chart, you'll need the XY
approach:

http://peltiertech.com/Excel/Charts/...olAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

Can you make use of this technique for custom markers?
http://peltiertech.com/Excel/ChartsH...omMarkers.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Trevor Williams" wrote in
message ...
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