Bubble chart with names in X and Y axis instead of numbers

[Federico]

Hello,

How could I do a bubble chart this way:
a b 23
a c 34
a d 12
b a 12
b c 111
b d 15
etc, etc... Instead of:
1 2 23
1 3 34
1 4 12
2 1 12
etc, etc
??

Thanks in advance,
Federico

 

[Guest]

I think what you are asking is how to make the axis lables show the a,b,c etc.
unfotunately the best way is to select each axis, goto patterns and select
None for tick mark lables. then use text boxes to put each lable whaer you
want it.
I do not know of a way to make a numeric axis as in xy or bubble charts
display text directly.

 

[Andy Pope]

Hi,

You will need you use numeric values to get the bubbles to plot.

If you are wanting category labels on the x and y axis then you could
use additional data series to do this by using each new points data label.

For a variation on this using xy scatter see Jon's example.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

 

[Federico]

Thanks a lot, that's working. It's a bit tedious, but it works.

Best,
Federico

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html