Degrees º as an imput in a x-y scatter plot

[Brad]

For two columns of data: column A where I have integers ranging from 0 to 90
representing degrees; and, a column B where I have integer values randomly
selected representing distance, I would like to create an x-y graph of
points representing degrees and distance from 0,0 intersect of the x and y
axes.

I suppose the end result should look like 1/4 of a circle, that is 90º of a
full circle.

Is this possible in a x-y scatter plot, or am I forced to use another chart
type?

My thanks in advance for any suggestions on handling the integers
representing degrees.

Brad

 

[Andy Pope]

Hi,

Assuming data in A1:B90 then the following 2 formula will return the x
and y position, which you can plot as a xy-scatter.

C1: =COS(A1*(PI()/180))*B1
D1: =SIN(A1*(PI()/180))*B1

See here for polar plots.
http://www.andypope.info/charts/polarplot.htm
http://www.andypope.info/charts/polarplot2.htm

Cheers
Andy

 

[Bernard Liengme]

Andy's answer is perfectly correct but one can also use Excels DEGREES and
RADIANS functions to make the conversion
C1: =COS(RADIANS(A1))*B1
D1: =SIN(RADIANS(A1))*B1
best wishes

 

[Bernard Liengme]

I meant Andy Pope, the second Andy need SIN for Y