Search code examples
google-sheetsgoogle-sheets-formulagoogle-sheets-api

Map data points onto an image in google sheets?


enter image description here

I'd like to be able to plot points onto this image automatically based on a data set in google sheets. Is this possible? If so, how do you do it?

Edit: For example, if I have the data

#1 - 7,8

#2 - 8,7

I'd like to plot those on the map like so:

enter image description here

First, I think I could have a stored table of the center pixel coordinates of each hex, then vlookup the coordinates (e.g. 8,7) on that table to pull the pixel coordinates. Then I have pixel coordinates to plot on the image, I am just unsure of how to plot them.


Solution

  • I ended up making a scatterplot on top of it using vlookup to convert the hex coordinates above to x and y pixel coordinates on the image.