How to label bubbles in a bubble chart
Hi, I have successfully created a bubble chart for members of my rowing squad and have four columns of data (person, age, distance and BMI) which I've plotted as bubbles with age on the x-axis and distance on the y-axis and BMI as the bubble size (see image). However, try as I might, I can't display the name of each person against their bubble. (I'm using the latest version of Mac OS and Numbers).
The closest I can get is below, when everyone's name is displayed against each bubble (see below).
Any suggestions please as to how I describe the data in the Name field? (In the second image I am using this 'Bubble Chart-1'::'Age, BMI & erg distance'::A1:A18). Thanks
iMac (Retina 5K, 27-inch, 2017), macOS Mojave (10.14)