how to create a wind rose in excel 2007

Posted by Patrick on Super User See other posts from Super User or by Patrick
Published on 2011-01-03T20:51:19Z Indexed on 2011/01/03 20:56 UTC
Read the original article Hit count: 834

Filed under:

I am attempting to create a wind rose graph (i.e.- here or here). My data is wind speed and cardinal wind direction in separate columns:

Wind (mph)  Wind Direction
3.66        SE
2.69        SE
2.62        SW
2.76        SW
2.11        NW
3.13        NW
3.55        SW
3.62        W

My final goal is to actually create the graph with a VBA macro, but I am unsure how to even create the graph manually. I can, if need be, convert the cardinal directions to degrees.

Any help is greatly appreciated

© Super User or respective owner

Related posts about excel

Related posts about excel-2007