Polar chart 2

[kmpillai]

Hi Friends,
How to plot a polar chart using excel?
My data is like this
Angle Value
63.5 deg 2000
90.2 deg 3800
118.5 deg 4472
151 deg 5510
149 deg 5710
147 deg 4000

Advance thanks

KMP

 

[diamondjim]

Why isn't your data?

Angle Value
63.5 deg 2000
90.2 deg 3800
118.5 deg 4472
147 deg 4000
149 deg 5710
151 deg 5510

What happens at 0 degrees
and 180 degrees?

 

[kmpillai]

Remaining all the angles beyond the specified range the value is zero. (ie. from 0 to 63 deg and 152 to 360 deg)

KMP

 

[GregLocock]

generate the xy coordinates and plot it as an xy plot, or interpolate for every angle and plot as a radar plot.

Cheers

Greg Locock

 

[kmpillai]

Hi Greg,
Thank you very much for your reply. First part of the answer is OK (xy plot). Could you please briefly tell about the interpolation in radar plot. In fact I tried the radar plot with the above data. It is dividing the 360 deg with the number of data points. I don't know how to proceed.

KMP

 

[GregLocock]

Generate a column 1-360. Fill the next column with linearly interpolated values from your data. Plot it as a radar plot

Cheers

Greg Locock