Excel Plotting Problem

[jrshaw03]

Hello All,

I am attempting to construct a 2D polar plot of a radar tracking event. The data X-Axis should be represent 0-360 Degress, but my data values look like this:

220
250
340
10
30
Passing 360 degress complicates things. The only way I can think to do this is to add 360 to each of the values that cross the 360 degree line. Has anyone run into this or have any ideas?

Thank you in advance for any suggestions,
Jimmy Shaw

 

[SkipVought]

Hi,

A polar plot requires 2 values: one for the angle and the other for the amplitude.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

I guess the angle is implied in the data. 360 divided by your number of data points.

Your date is amplitude, not angle.

You have 5 data points. 360 / 5 is 72 degrees per point.

So the fist data point is at 72 degrees, amplitude 220

Second at 144 degrees, amplitude 250.

etc.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}