excel 最简单画风向玫瑰 详细步骤

xiaonuanl

一、首先找到你想要画的时间段的风向数据，我是用十分钟平均的，每天有24个数据。一个月的数据=24*31（/30/29/28）。
二，然后计算出每个风向的频率,要先把度数换算成风向，换算表如下，下面给出公式。A2：AE25是数据范围


N     =(COUNTIF(A2:AE25,">=0")-COUNTIF(A2:AE25,">=11.26")+COUNTIF(A2:AE25,">=348.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NNE  =(COUNTIF(A2:AE25,">=11.26")-COUNTIF(A2:AE25,">=33.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NE  =(COUNTIF(A2:AE25,">=33.76")-COUNTIF(A2:AE25,">=56.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
ENE  =(COUNTIF(A2:AE25,">=56.26")-COUNTIF(A2:AE25,">=78.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
E =(COUNTIF(A2:AE25,">=78.76")-COUNTIF(A2:AE25,">=101.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
ESE =(COUNTIF(A2:AE25,">=101.26")-COUNTIF(A2:AE25,">=123.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SE =(COUNTIF(A2:AE25,">=123.76")-COUNTIF(A2:AE25,">=146.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SSE =(COUNTIF(A2:AE25,">=146.26")-COUNTIF(A2:AE25,">=168.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
S =(COUNTIF(A2:AE25,">=168.76")-COUNTIF(A2:AE25,">=191.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SSW =(COUNTIF(A2:AE25,">=191.26")-COUNTIF(A2:AE25,">=213.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SW =(COUNTIF(A2:AE25,">=213.76")-COUNTIF(A2:AE25,">=236.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
WSW =(COUNTIF(A2:AE25,">=236.26")-COUNTIF(A2:AE25,">=258.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
W =(COUNTIF(A2:AE25,">=258.76")-COUNTIF(A2:AE25,">=281.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
WNW =(COUNTIF(A2:AE25,">=281.26")-COUNTIF(A2:AE25,">=303.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NW =(COUNTIF(A2:AE25,">=303.76")-COUNTIF(A2:AE25,">=326.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NNW =(COUNTIF(A2:AE25,">=326.26")-COUNTIF(A2:AE25,">=348.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
C =(COUNTIF(A2:AE25,"静风"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
就得到了各个风向对应的频率了，然后
三、选择这两列数据，插入图表，就能得到了风向玫瑰图啦，是不是这是最简单的方法

N	0.038978495
NNE	0.248655914
NE	0.376344086
ENE	0.142473118
E	0.047043011
ESE	0.021505376
SE	0.009408602
SSE	0.016129032
S	0.016129032
SSW	0.00672043
SW	0.00672043
WSW	0.004032258
W	0.010752688
WNW	0.017473118
NW	0.01344086
NNW	0.021505376
C	0.002688172

sharrow

呵呵，还不错，楼主辛苦了

hulalahulala

赞！简单实用

南国的佳人

赞赞赞~\(≧▽≦)/~
谢谢楼主分享

nijat116

很实用啊！！！！！！

迷糊加油

谢楼主分享啊~~

mbt125

很实用，感谢楼主分享

独孤酒见

很实用，感谢楼主分享

xgqqxg

谢谢分享

Liuxz

666666666666666