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
Barb Reinhardt - 28 Apr 2007 18:00 GMT
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
> Is it possible to create a bubble chart with two series that share the same
> X and Y values. For example:
[quoted text clipped - 14 lines]
>
> Bob
Bob Flanagan - 28 Apr 2007 23:02 GMT
Barb, many thanks.
Bob
> Go to your graph
> Select Chart -> Source Data
[quoted text clipped - 26 lines]
>>
>> Bob