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

Not sure if this helps but: (!)
Formulas for row 2 (assuming row 1 is headings)
X axis formula =COS(RADIANS(A2))*B2
Y axis formula =COS(RADIANS(A2))*B2

and chart the resultant data on a scatter chart.

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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