Getting Radar Chart to Display Data Correctly

[cdorgan]

I am trying to plot the attached data on a radar chart to show the wind direction (0 to 350 degrees in 10 degree increments) and the occurance by severity (wind speed buckets - the columns in the table). The chart is based on selecting a weather station.

The main problem is that the radar chart keeps rearranging the wind direction - putting the highest severity-direction combination first. Also, as I add in each wind speed bucket, the chart changes.

Any help would be greatly appreciated.

Station ID	Station Tag	Wind Direction	1.3 - 4	4 - 8	8 - 13
010831 BHM	BIRMINGHAM INTL AP, AL	0	0.3	1.3	1.4
010831 BHM	BIRMINGHAM INTL AP, AL	10	0.4	1.1	1
010831 BHM	BIRMINGHAM INTL AP, AL	20	0.4	0.9	0.6
010831 BHM	BIRMINGHAM INTL AP, AL	30	0.5	1	0.4
010831 BHM	BIRMINGHAM INTL AP, AL	40	0.6	1.4	0.3
010831 BHM	BIRMINGHAM INTL AP, AL	50	0.6	1.4	0.4
010831 BHM	BIRMINGHAM INTL AP, AL	60	0.5	1.1	0.5
010831 BHM	BIRMINGHAM INTL AP, AL	70	0.4	1	0.6
010831 BHM	BIRMINGHAM INTL AP, AL	80	0.3	0.9	0.6
010831 BHM	BIRMINGHAM INTL AP, AL	90	0.3	1	0.6
010831 BHM	BIRMINGHAM INTL AP, AL	100	0.3	0.8	0.6
010831 BHM	BIRMINGHAM INTL AP, AL	110	0.3	0.8	0.7
010831 BHM	BIRMINGHAM INTL AP, AL	120	0.3	1	0.8
010831 BHM	BIRMINGHAM INTL AP, AL	130	0.3	1	0.8
010831 BHM	BIRMINGHAM INTL AP, AL	140	0.3	1.1	1
010831 BHM	BIRMINGHAM INTL AP, AL	150	0.3	1.1	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	160	0.3	1	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	170	0.2	0.9	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	180	0.1	0.8	1
010831 BHM	BIRMINGHAM INTL AP, AL	190	0.1	0.7	1.1
010831 BHM	BIRMINGHAM INTL AP, AL	200	0.1	0.6	1.1
010831 BHM	BIRMINGHAM INTL AP, AL	210	0.1	0.6	1
010831 BHM	BIRMINGHAM INTL AP, AL	220	0.1	0.6	1
010831 BHM	BIRMINGHAM INTL AP, AL	230	0.1	0.6	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	240	0.1	0.6	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	250	0.1	0.6	0.8
010831 BHM	BIRMINGHAM INTL AP, AL	260	0.1	0.6	0.7
010831 BHM	BIRMINGHAM INTL AP, AL	270	0.1	0.6	0.7
010831 BHM	BIRMINGHAM INTL AP, AL	280	0.1	0.6	0.8
010831 BHM	BIRMINGHAM INTL AP, AL	290	0.1	0.6	0.9
010831 BHM	BIRMINGHAM INTL AP, AL	300	0.1	0.6	0.8
010831 BHM	BIRMINGHAM INTL AP, AL	310	0.1	0.7	1
010831 BHM	BIRMINGHAM INTL AP, AL	320	0.1	0.7	1
010831 BHM	BIRMINGHAM INTL AP, AL	330	0.1	0.7	1
010831 BHM	BIRMINGHAM INTL AP, AL	340	0.1	0.8	1.2
010831 BHM	BIRMINGHAM INTL AP, AL	350	0.2	1.1	1.3

Here is a screen shot of what I am getting when I plot the data.

Wind Radar Chart Screen Shot

[jdbuchanan71]

@cdorgan 

You should be able to change the sort by under more options: