I can't figure out how to change the radii of the bubbles in a bubble chart in Numbers. I tried taking the original data and dividing it by 10, or 100, and redirecting the Size: data to the new column, but the bubble size hasn't changed.
I'm finding Numbers to be frustratingly counterintuitive, and haven't found any mention of this yet on the Numbers Help Page.
Edit: I used a circle detecting script to find the eclipse in the frames of a video, then I plotted the x,y coordinates of each circle, and wanted to use the radius of the found circles for the size of the bubbles—there probably isn't enough variation to matter, but obviously being so large is useless.
Best Answer
@user2421192's comment had the solution: apparently the bubbles are automatically scaled proportionally to the range of the radius data. So by adding a new
rowat the top of my data, without x or y data, but just a r radius value, rescaled the rest of the data.Since the radii I have don't vary by much, I decided to modify them with a formula, taking the
expof the original radiusrdivided by ten (exp(r/10)), and then setting my "scale" radius to50 * max(radius)(of the rest of the column), which gives some variation in the bubbles that makes it a little clearer whether they're bigger or smaller than the rest.