Bubble Chart: Why is simple so hard?

[Dustin Olson]

I have a very simple table of data... x-axis with "text definers" and y-axis with "text definers", and in the middle data... I just want to show a bubble chart with the x/y axis and the bubbles sized by the middle data. But, I can't define both axis. What am I missing? What can I use to do this?

	Spring	Summer	Fall	Winter
Bob	12​	10​	87​	98​
Jane	4​	45​	16​	111​
Fred	56​	78​	73​	31​
Frank	89​	23​	88​	62​
Dustin	1​	134​	19​	75​

 

[James006]

Hi,

Jon Peltier has a very good explanation

Control Excel Bubble Chart Bubble Sizes

Here's how to control the sizes of bubbles in bubble charts in Microsoft Excel.

peltiertech.com

Hope this will help