Bubble Chart question

  • Thread starter Thread starter Bob Flanagan
  • Start date Start date
B

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
 
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
 
Barb, many thanks.

Bob

Barb Reinhardt said:
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
Click to expand...
 
Back
Top