Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am attempting to create a wind rose graph, i.e.



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.

share|improve this question
I assume this is next to impossible without external software to create the graph. I ended up creating the graph in PHP. – Patrick Jan 24 '11 at 17:54
I got curious and googled a little bit:… – molgar Feb 21 '11 at 16:57
up vote 3 down vote accepted

You can create something basic much like your first sample using a standard Excel "filled radar chart". You'll need to summarise your data into a table like this - make sure the higher-valued column comes first. It can probably be done just with some "countif" formulas from your input data, not even VBA.

    H   M   L
N   5   4   1
NE  7   5   2
E   9   6   3
SE  11  5   4
S   10  6   5
SW  5   5   4
W   4   3   3
NW  2   1   2

share|improve this answer

I researched and believe that the only way to create a wind rose graph in excel 2007 is by using external programs that then import the image into excel.

Since I was seeking a way to create the wind rose completely within excel using a VBA macro, I believe this problem to be currently unsolvable.

share|improve this answer

I had a good search around and found this site very helpful:

It's cheap and it simple to use. Runs using excel with some built in VBA coding to produce wind roses like the one below.

enter image description here

share|improve this answer

This site has software you can download to do this in Excel. I didn't try it, but from the user manual it looks like what you want. Bonus: available in in English and Greek! ;-)

This site suggests using R to create the graph. R is statistical computation and graphics package. I've seen some nice output from it. I suspect it will require some work before you will be able to use it efficiently.

share|improve this answer

It's actually simple - just create a filled radar chart. Create a column of data with multiple points for each direct, say 10 separated by a null or low value point.

share|improve this answer
Could you possibly go into further detail, possibly with test values or a screenshot? – Insane Oct 15 '15 at 22:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.