Polar graphing

[lynz]

is there a way to create a polar graph on Excel?

 

[PaddyD]

2 suggestions:

1) convert the data...the following is a quote from Chip Pearson to the excel charting group:

Convert your polar coordinates to rectangular, and choose an XY
Scatter plot.

X = R * COS(RADIANS(Theta))
Y = R * SIN(RADIANS(Theta))

You won't get the polar grid lines, but the graph will be polar.

2) take a look at the 'funchrt6.zip' file here:

http://www.bmsltd.co.uk/Excel/Default.htm

which has an example.

Paddy