Google-sheets – Google Sheets Scatter chart: multiple data points at same X location

You could use INSERT > Link... to add a link to the active cell but it will require you to write the URL.

If you want that the URL be added automatically, you will need a Google Apps Script.

Instead, you could use a formula with the HYPERLINK function in a temporary column and use some built-in functions to do bulk operations.

I.E. if the search term is in A1 then use the following formula:

=hyperlink("www.google.com/search?q="&A1,A1)

Fill down as necessary.
Copy and paste as values over the column with the search terms.
Delete the temporary column.

Related keyboard shortcuts

Insert a link: CTRL+k
Copy: Ctrl+c
Paste as values: Ctrl+Shift+v

References

• HYPERLINK - Docs editors Help
• Extend Google Docs, Sheets, and Forms with Apps Script - Docs editors Help

With a sleight of hand, you can use Bubble chart for this.

First, you'll need to move your data a bit (this can be arranged automatically) so that the name of data series appear in its own column, in every row that belongs to the series. This is Column D below. Columns B and C are x- and y- values. Column A is intentionally left blank (it is ordinarily the text that's written on the bubble.)

+---+------+------+-----+----+
| A |  B   |  C   |  D  | E  |
+---+------+------+-----+----+
|   | 1    | 4.00 | #2i |  1 |
|   | 2    | 1.41 | #2i |  1 |
|   | 3    | 1.73 | #2i |  1 |
|   | 4    | 2.00 | #2i |  1 |
|   | 5    | 2.24 | #2i |  1 |
|   | -0.5 | 1.22 | #2o |  1 |
|   | 0.5  | 1.58 | #2o |  1 |
|   | 1.5  | 1.87 | #2o |  1 |
|   | 2.5  | 2.12 | #2o |  1 |
|   | 0.7  | 1.70 | #3o |  1 |
|   | 1.7  | 2.70 | #3o |  1 |
|   | 2.7  | 3.70 | #3o |  1 |
|   | 3.7  | 4.70 | #3o |  1 |
|   | 4.3  | 4.00 | #3o |  1 |
|   | 0    | 0.00 |     | 10 |
+---+------+------+-----+----+

Column E gives the size of each bubble, in some relative terms. It is optional, but if you omit it, or put the same number everywhere, the bubbles will be much too large. My workaround is to add a dummy data point (last row), which gets size 10, so that the real data points will become proportionally smaller. To hide this dummy point, I put a space in its column D, and made the color of the bubble white (I also removed the border of all bubbles, otherwise it was still showing).

A bit too much fuss for my liking, but this is the only way I know.