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