View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Bubble Chart question

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