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

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

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.

"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
>

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

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

Best,
Federico

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

Andy Pope <[email protected]> wrote in message news:<[email protected]>...
> 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