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
(E-Mail Removed)

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