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

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

Hi Federico,

To create a bubble chart with names in the X and Y axis instead of numbers, you can follow these steps:

1. Enter your data in a table with the following columns: X-axis name, Y-axis name, and bubble size. For example:
   
   
   Formula:

   ---

   | X-axis name | Y-axis name | Bubble size |
|-------------|-------------|-------------|
| a           | b           | 23          |
| a           | c           | 34          |
| a           | d           | 12          |
| b           | a           | 12          |
| b           | c           | 111         |
| b           | d           | 15          | 


   ---

2. Select the entire table, including the column headers.
   
3. Click on the "Insert" tab in the ribbon.
   
4. Click on the "Insert Scatter (X, Y) or Bubble Chart" button.
   
5. Select the "Bubble" chart type.
   
6. Your chart should now be created with the X-axis and Y-axis labels showing the names you entered in the table.
   
7. To format the chart, you can use the "Chart Design" and "Chart Format" tabs in the ribbon. For example, you can add a chart title, change the axis labels, and adjust the bubble sizes.

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 wrote in message ...
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