Bubble Chart w/ Y-Axis Categories

[jlibrizzi]

I have a two dimensional table similar to:
Circle Square Triangle
Red 2 5 3
Blue 7 1 6
Green 3 4 8
Orange 1 0 9

and want to create a bubble chart where the shape category is on one axis, the color category is on the other axis, and bubbles appear at each intersection displaying the value via its size.

I'm struggling to make this happen and would greatly appreciate any assistance.
(Excel 2010)

 

[pgc01]

Hi
Welcome to the board

You can do it following these steps

1 - normalise the table (instead of a 2D table write it with simple records like "Blue, Triangle, 6")
2 - replace the categories with numbers, like for the Colour (1,2,3,4) and for the format (1,2,3)
3 - you can now create the bubble chart
4 - replace the numbers in the axes with the corresponding categories

If you have problems post back.

 

[jlibrizzi]

Great idea, pgc01! Thanks very much!

 

[pgc01]

You're welcome. Thanks for the feedback.