I want to make a scatter graph with 3 different data series:
$B$2:$B$10 vs $C$2:$C$10, with labels from $A$2:$A$10
$B$11:$B$16 vs $C$11:$C$16, with labels from $A$11:$A$16
$B$17:$B$23 vs $C$17:$C$23, with labels from $A$17:$A$23
I follow instructions and add labels to each dataseries, but I get the values of $A$2:$A$10 for all plots.
There are similar questions around, but they are closed with solutions that didn’t work.
See test file here, and copied as text below.
scat_labels.xlsx (11.6 KB)
| pulse | density | power |
|---|---|---|
| 94123 | 2.75 | 5.09 |
| 95307 | 3.28 | 4.29 |
| 100844 | 3.41 | 4.40 |
| 94119 | 3.79 | 4.62 |
| 94120 | 3.82 | 4.28 |
| 94033 | 4.30 | 4.95 |
| 100841 | 4.98 | 5.86 |
| 94114 | 5.14 | 6.34 |
| 95467 | 5.45 | 6.01 |
| 99472 | 2.91 | 3.41 |
| 99472 | 3.18 | 2.99 |
| 99470 | 3.21 | 3.15 |
| 99474 | 3.64 | 3.46 |
| 99471 | 4.03 | 3.77 |
| 99474 | 4.47 | 4.59 |
| 100195 | 2.35 | 2.14 |
| 100205 | 2.62 | 1.75 |
| 98969 | 3.16 | 2.54 |
| 100202 | 3.20 | 2.76 |
| 100197 | 3.63 | 2.63 |
| 100202 | 3.83 | 3.33 |
| 100196 | 4.24 | 3.22 |