Plotting multiple data series in a bubble chart

[Dhananjay]

Hello,

Would you please help me out in creating multiple data series in bubble chart.

I have four parameters as
Series: name
X axis: value
Y axis: value
Size : value

I can select the individual series and edit all those parameter for
individual series, but it's very cumbersome task? do we need to arrange our
data in some order to get the direct multiple data series in a bubble chart.

Please let me know your comments.... waiting for reply !!!

 

[Del Cotter]

Would you please help me out in creating multiple data series in bubble chart.

I tried to do this recently, and it was a nightmare! In the end, I
accepted that the Series name would not read properly, and amended the
cell references by hand.

Leaving aside the series name, the one-shot arrangement for multiple
bubble series should be, IIRC:

X1, Y1, S1, Y2, S2, Y3, S3, etc.

Where Xn, Yn, and Sn are the X, Y and Size ranges respectively. Series
1, 2, 3 etc. end up sharing the same X range, X1, but they can be
manually fixed to each have their own X range afterward.

Alternatively, you can abandon the one-shot approach and add them
separately:

X1, Y1, S1

The first series is created using the wizard.

X2, Y2, S2

Further series are added to the chart thus created, using either Copy,
Paste Special, or Chart.. Add Series. The series names should then work
properly, but I forget whether they're supposed to go over the Y-range
or the Size range.