Hi,

2 ways depending on how much control over the size and spacing you need.
First way is to plot a series of points at the same xy location use the
circle marker with no backcolor. Alter the size of each marker to get a
set of concentric rings.

For move control you will need to plot each ring as a series of xy lines
where the points are derived from simple trig formula.
Have a look at how the outer ring of the gauge chart is plotted.
http://www.andypope.info/charts/gauge.htm

If you have problems post back.

Cheers
Andy

Ali Baba wrote:
Hi

Is it possible to draw a number of equally spaced circles (say 5) around a
point in a chart??

I mean that my chart will look like this when I run the VBA procedure.
http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info