Hi,

Maybe this is more of a math question but I'm trying to re-create the below (except with more accurate circles rather than all being the same size). My data would change month to month and the bubbles would update accordingly but if I could replicate this than I can populate it with my data.

Probability Circle.png

The problem I'm having is that the scaling is throwing me off and I'm not sure how to use it to adjust my axis positions.

Right now, I have the X-axis and Y-axis at 0-100.
My bubble size is the total of each category (28 for Cats, 19 for Dogs, 15 for Birds). I'm playing around with it but have had no avail. Not sure if this is necessarily an "excel" question but if I could better understand the scaling works, maybe I could figure it out myself.

Thanks,
Dan