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 wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info