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

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

Ali Baba:
This may qualify as a 'kludge' but, you could create your chart as a Bubble
chart.
Set your bubble series 'Options' to:
'Size represents: Width of bubbles' and
'Scale bubble size to: 220% of default'
Then, select each 'Line' series and: 'Chart | Add trendline' (format your
trendlines as you would like)

X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2
2.0 1.5 4.0
2.0 1.5 3.0
2.0 1.5 2.0
2.0 1.5 1.0

0.0 -1.0 0.0
1.7 4.0 0.0
1.2 2.5
0.0
2.0 1.5
0.0

If you'd like I'd be happy to e-mail an example of this method.
Unfortunately, I don't have a website I can post it to.

MikeM

"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

Sorry, my spacing did not work properly:

FOR the following series (plotted by colums):
X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2

X: 2.0 Y: 1.5 BUBBLE1: 4.0
X: 2.0 Y: 1.5 BUBBLE2: 3.0
X: 2.0 Y: 1.5 BUBBLE3: 2.0
X: 2.0 Y: 1.5 BUBBLE4: 1.0

X: 0.0 Y: -1.0 'LINE1': 0.0
X: 1.7 Y: 4.0 'LINE1': 0.0
X: 1.2 Y: 2.5 'LINE2': 0.0
X: 2.0 Y: 1.5 'LINE2': 0.0

MikeM

"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

I have to apologize to anyone reading this (attempted) post:
There is one more thing I need to add to get this method to work:
Create your first Bubble series. Once the chart is created, select your
chart, and go to 'Chart | Source data | Series' and add your successive
bubble series through this form. Then, add the trendlines to the 'fake' line
series.

MikeM

"MikeM" wrote:

Sorry, my spacing did not work properly:

FOR the following series (plotted by colums):
X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2

X: 2.0 Y: 1.5 BUBBLE1: 4.0
X: 2.0 Y: 1.5 BUBBLE2: 3.0
X: 2.0 Y: 1.5 BUBBLE3: 2.0
X: 2.0 Y: 1.5 BUBBLE4: 1.0

X: 0.0 Y: -1.0 'LINE1': 0.0
X: 1.7 Y: 4.0 'LINE1': 0.0
X: 1.2 Y: 2.5 'LINE2': 0.0
X: 2.0 Y: 1.5 'LINE2': 0.0

MikeM

"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

Hi Mike
please send me your example

"MikeM" wrote:

I have to apologize to anyone reading this (attempted) post:
There is one more thing I need to add to get this method to work:
Create your first Bubble series. Once the chart is created, select your
chart, and go to 'Chart | Source data | Series' and add your successive
bubble series through this form. Then, add the trendlines to the 'fake' line
series.

MikeM

"MikeM" wrote:

Sorry, my spacing did not work properly:

FOR the following series (plotted by colums):
X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2

X: 2.0 Y: 1.5 BUBBLE1: 4.0
X: 2.0 Y: 1.5 BUBBLE2: 3.0
X: 2.0 Y: 1.5 BUBBLE3: 2.0
X: 2.0 Y: 1.5 BUBBLE4: 1.0

X: 0.0 Y: -1.0 'LINE1': 0.0
X: 1.7 Y: 4.0 'LINE1': 0.0
X: 1.2 Y: 2.5 'LINE2': 0.0
X: 2.0 Y: 1.5 'LINE2': 0.0

MikeM

"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

I prefer something like when you click on a point this will show the circles

Or you click on a command button and specify the coordinates

I can send you the example XLS file; what e-mail address should I use?
Mike

"Ali Baba" wrote:

Hi Mike
please send me your example

"MikeM" wrote:

I have to apologize to anyone reading this (attempted) post:
There is one more thing I need to add to get this method to work:
Create your first Bubble series. Once the chart is created, select your
chart, and go to 'Chart | Source data | Series' and add your successive
bubble series through this form. Then, add the trendlines to the 'fake' line
series.

MikeM

"MikeM" wrote:

Sorry, my spacing did not work properly:

FOR the following series (plotted by colums):
X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2

X: 2.0 Y: 1.5 BUBBLE1: 4.0
X: 2.0 Y: 1.5 BUBBLE2: 3.0
X: 2.0 Y: 1.5 BUBBLE3: 2.0
X: 2.0 Y: 1.5 BUBBLE4: 1.0

X: 0.0 Y: -1.0 'LINE1': 0.0
X: 1.7 Y: 4.0 'LINE1': 0.0
X: 1.2 Y: 2.5 'LINE2': 0.0
X: 2.0 Y: 1.5 'LINE2': 0.0

MikeM

"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

This is my email


thanx


"MikeM" wrote:

I can send you the example XLS file; what e-mail address should I use?
Mike

"Ali Baba" wrote:

Hi Mike
please send me your example

"MikeM" wrote:

I have to apologize to anyone reading this (attempted) post:
There is one more thing I need to add to get this method to work:
Create your first Bubble series. Once the chart is created, select your
chart, and go to 'Chart | Source data | Series' and add your successive
bubble series through this form. Then, add the trendlines to the 'fake' line
series.

MikeM

"MikeM" wrote:

Sorry, my spacing did not work properly:

FOR the following series (plotted by colums):
X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2

X: 2.0 Y: 1.5 BUBBLE1: 4.0
X: 2.0 Y: 1.5 BUBBLE2: 3.0
X: 2.0 Y: 1.5 BUBBLE3: 2.0
X: 2.0 Y: 1.5 BUBBLE4: 1.0

X: 0.0 Y: -1.0 'LINE1': 0.0
X: 1.7 Y: 4.0 'LINE1': 0.0
X: 1.2 Y: 2.5 'LINE2': 0.0
X: 2.0 Y: 1.5 'LINE2': 0.0

MikeM

"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