Google sheets, scatter plot, multiple datasets, with datapoint labels

Question

I want to create a scatterplot in Google sheets with multiple datasets, and yet still be able to add data labels for each data point. Additionally, it's two independent axis, which means some X values will have multiple Y values.

Example sheet: This sheet is almost what I want, except I want data labels to show up beside each point and I also want to do multiple different color datasets on the same plot. https://docs.google.com/spreadsheets/d/1EZ78WNVvvpggP8L52H-yuh-ICJEkd9XCOrX752nHw1I/edit?usp=sharing

Answer 1

If by "add data labels for each data point" you mean "adding labels from A column to each individual point" - then that is not possible. you can add only values as a label for each data point.

As for "two independent axis" - this can be easily achieved by adding new series from another column. All the above would look like:

From there you can add trendlines or customize each individual data point by changing color, size and shape:

If you will re-shape your table a bit you could do this:

Of course, if you really want so you could add custom label per each data point manually by inserting a drawing:

---

demo sheets: one, two