Please find below a pie chart with a green cross (example of a specific x,y-coordinate).
The pie chart does have different sized parts. Question: how to calculate (in Excel) what part of the pie matches the coordinates?
x,y is cartesian coordinates. Angle + radius is polar coordinates. Look up how to convert one into the other. Given the angle, you can find which of the parts contains the point.
Thanks. After your to the point ‘teaser’ I found that Excel has a built-in ATAN2 function and a circle degree converter. Thanks for bringing me up to speed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.