controlling bubble size in bubble chart
How does one control the size of the bubbles that are drawn in a bubble chart? From what I can tell from limited experimentation is that Numbers automatically picks the sizes it displays, scaling the bubble area (or diameter) so that the largest value in the weight series is shown as the largest bubble, at a fixed size (roughly an inch), with lower values proportionally smaller. (so, for example, the series of weights 1,2,3,4,5 displays exactly the same as 10,20,30,40,50, and if you display, say, only 30,40,50 you get three bubbles the same sizes as the last three of those). Is there any way to change things so that the largest bubble is a different size -- say 1/2" or even 1/4"?
Ted Lee
Minnetonka, MN
MacBook Pro (Retina, 13-inch, Late 2012), OS X Yosemite (10.10.5)