Display Data as distance from a point

[MG12345]

Hey Good day, I have data from a table and its angles in a circle, and then distance from the center point.

Currently the data is in Mils but I'm willing to set up extra columns to convert it to degrees if needed.

thats an example of what the data table looks like, it's in a continuous row(i just modified it to be easier to see) and goes to 20 slices of angle, using between from 1 to 20 of them.
I'm also willing to change up the layout if needed.

that's the ideal end result. i just made it up on PowerPoint to give you a visual of what it could hopefully look like.
It's probably not super accurate, but just to give you a reference of data to end result.
I have a 365 business account, and I'm willing to try to export it to another 365 program if needed.

thanks for your time, any help or ideas is appreciated

 

[MG12345]

it figured it out, I need to convert my data into x and y coordinates in a separate table

using =(distance)*(COS((angleinmills)/3200*PI())) for x coordinate
using =(distance)*(COS((angleinmills)/3200*PI())) for y coordinate

then used x column as my x data
y column as my y data

i also created a circle as a separate data set bigger than my largest point, so that the chart wouldn't shrink in certain directions

 

[MG12345]

it figured it out, I need to convert my data into x and y coordinates in a separate table

using =(distance)*(COS((angleinmills)/3200*PI())) for x coordinate
using =(distance)*(COS((angleinmills)/3200*PI())) for y coordinate

then used x column as my x data
y column as my y data

i also created a circle as a separate data set bigger than my largest point, so that the chart wouldn't shrink in certain directions

View attachment 93321

refrence my last post,
using =(distance)*(COS((angleinmills)/3200*PI())) for x coordinate
using =(distance)*(sin((angleinmills)/3200*PI())) for y coordinate

as well as in the image, distance is actually angle in mils, and r is distance in radius

sorry about that

 

[MG12345]

so, I needed to convert my data into x and y coordinates in a separate table

x coordinate formula =Distance*(COS((angleinmills+1600)/3200*PI()))
y coordinate formula =Distance*(SIN((angleinmills+1600)/3200*PI()))

I had to also check values in reverse order to get it to go clockwise instead of counterclockwise, like a compass does
and the +1600 in the formula is to rotate it to the North.

sorry about the confusing posts, while I had it partially figured out.