google sheetsgoogle-sheets-charts
I've tried using the built-in scatter plot chart and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data like the following:
| Name1 | 36 | 1 |
| Name2 | 22 | 3 |
| Name3 | 21 | 6 |
| Name4 | 4 | 2 |
| Name5 | 8 | 2 |
How do I label the point at (8,2) on the scatter plot as Name5, and so on?
Copy of a more extreme example of 'co-linearity`:
seems to have pointed to an acceptable solution/workaround. That is, add data point markers (Point size, in Customise in Chart Editor) - in the image to one [red] data series (also with the line made thinner than the default and the other [blue] series line increased in width).
If the row you are using for labels contains dates, the spreadsheet supposes that you need an accurate representation of time. So it arranges the data chronologically and marks the time axis at equal time intervals:
If you want the specific dates to be used as labels, this means they should be used like text labels. Select the top row and apply Format->Number->Plain Text:
Now the columns are labeled with the text from the top row, and they are presented in the order of appearance in the spreadsheet.
Best Answer
Using a cell_object instead of just a value worked for me