Help with a project - related to regions within an XY graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2644607%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20project%20-%20related%20to%20regions%20within%20an%20XY%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2644607%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%20I'm%20working%20on%20a%20project.%20So%20basically%20I%20modelled%20a%20graph%20on%20excel%20using%20XY%20scatter%20plot.%20All%20the%20lines%20are%20done%20with%20XY%20data%20points%2C%20but%20I%20should%20be%20able%20to%20get%20the%20line%20equations%20relatively%20easy%20as%20I%20already%20have%20the%20points.%20My%20question%20now%20is%20for%20each%20point%20on%20the%20graph%20(eg.%20the%20green%20cross%20represents%20a%20point)%2C%20I%20want%20to%20check%20which%20region%20it%20is%20in%20and%20output%20the%20name%20of%20its%20region%20(eg.%20the%20green%20cross%20is%20in%20region%206).%20Is%20there%20anyway%20I%20can%20do%20this%20in%20Excel%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ken_322_0-1628843022326.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302988iCF7C4C479BDA8D91%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ken_322_0-1628843022326.png%22%20alt%3D%22Ken_322_0-1628843022326.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2644607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748916%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20project%20-%20related%20to%20regions%20within%20an%20XY%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748916%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1127628%22%20target%3D%22_blank%22%3E%40Ken_322%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20create%20following%20Scatter%20chart%20by%20using%20No%20Code%20Data%20Visualization%20add-in.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20check%20here%20for%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-In%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMreGwrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMicrosoft%20Excel%20%26amp%3B%20Office%20365%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%20you%20are%20comfortable%20with%20Google%20Sheets%2C%20you%20can%20find%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-On%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMrZ3MrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Qaiser_j_0-1631622580319.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310296i830EE1CFC657CF6A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Qaiser_j_0-1631622580319.png%22%20alt%3D%22Qaiser_j_0-1631622580319.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

Ken_322_0-1628843022326.png

 

1 Reply

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

 

Qaiser_j_0-1631622580319.png