Bubble Chart question

[Bob Flanagan]

Is it possible to create a bubble chart with two series that share the same
X and Y values. For example:

X Y values1 values2
10 11 300 0
14 20 150 0
20 5 0 100
30 30 0 40

I obviously haven't had any success <grin>. I can create a bubble graph
with the x y and value1. But I can't figureout how to get values2 with the
same x and y. I can create an entirely seperate x y and values2 and add as
a new series, but my data is not constructed that way and it would be a pain
to re-arrange.

Thanks for any suggestions

Bob

 

[Guest]

Go to your graph
Select Chart -> Source Data
Select the SERIES tab and enter another with the X,Y and size values you
want.

HTH,
Barb Reinhardt

 

[Bob Flanagan]

Barb, many thanks.

Bob

Go to your graph
Select Chart -> Source Data
Select the SERIES tab and enter another with the X,Y and size values you
want.

HTH,
Barb Reinhardt