安徽农业科学2012，Vol.40Issue(1)：397-399,3.
用Excel雷达图制作多彩色风玫瑰图的实用技巧
Practical Skills of Multi-colored Wind Rose Diagram Using Excel Radar
段红梅 1匡方毅 2王璐 2邱庆栋2
作者信息
- 1. 湖南省娄底市气象局,湖南娄底417000
- 2. 湖南省长沙市气象局,湖南长沙410205
- 折叠
摘要
Abstract
This article describes practical skills of how to make multi-colored wind rose diagram using Excel radar chart software, and compares the products, it indicates that the use of the skills for making the wind rose products are better than products that don't use. Practical skills are concluded that; ① Realize more color wind rose diagram principle: Excel chart function is support for more series data graphics drawing in a picture, using radar chart, to realize multiple wind, and wind speed, static wind profile line and coloring. ② Through splitting wind data source, to realize 16 independent color wind graphics area establishment automatically, and can adjust and fill graphics regional color and boundary color separately. ③ Through increasing data sources, to increase static wind frequency and wind speed profile line as well as features coordinates profile line graphics in the same chart. ④ If a data graphics is covered, you can change the order of data series in the property or the data location in the table. ⑤Make classical wind rose diagram, data modifications should be assigned zero, then change into negative static wind frequency value, and set coordinate minimum as the negative value of static wind frequency.关键词
多彩色风玫瑰图/Execl/雷达图/实用技巧Key words
Multi-colored wind rose diagram/ Execl software/ Radar chart/ Practical skills分类
天文与地球科学引用本文复制引用
段红梅,匡方毅,王璐,邱庆栋..用Excel雷达图制作多彩色风玫瑰图的实用技巧[J].安徽农业科学,2012,40(1):397-399,3.
