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

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

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

Brad wrote:
> 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'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 V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brad" <lreid@flash.net> wrote in message
news:Op6DW6OMHHA.2028@TK2MSFTNGP03.phx.gbl...
> 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
>

I meant Andy Pope, the second Andy need SIN for Y
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:%23FjWDMPMHHA.4196@TK2MSFTNGP03.phx.gbl...
> 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 V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Brad" <lreid@flash.net> wrote in message
> news:Op6DW6OMHHA.2028@TK2MSFTNGP03.phx.gbl...
>> 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
>>
>
>