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


"Bob Flanagan" wrote:

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

Bob

"Barb Reinhardt" wrote in message
...
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" wrote:

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