how to create a wind rose in excel 2007
- by Patrick
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