Hey guys, I'm working on a project. So basically I modelled a graph on excel using XY scatter plot. All the lines are done with XY data points, but I should be able to get the line equations relatively easy as I already have the points. My question now is for each point on the graph (eg. the green cross represents a point), I want to check which region it is in and output the name of its region (eg. the green cross is in region 6). Is there anyway I can do this in Excel?
Cheers
Hi @Ken_322
I create following Scatter chart by using No Code Data Visualization add-in.
You can check here for Microsoft Excel & Office 365.
And if you are comfortable with Google Sheets, you can find here.
Thanks
