up vote 0 down vote favorite
1
share [g+] share [fb]

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

here

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.

link|improve this question
100% accept rate
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
If your answer to your question was that it was close to impossible, add an answer to this question stating what you discovered and what you did and accept that as the answer to the question. Someone might find the information useful later if they come across this question. – Troggy♦ Jan 24 '11 at 18:43
@Troggy ok, thanks. I wasn't sure if that was the preferred method for these types of questions – Patrick Jan 24 '11 at 19:18
Yes, you can answer your own question if it is truely the answer to the your question. The other purpose of Super User is to be a reference for people to reference questions/answers in the future. Also see: meta.superuser.com/questions/1621/… – Troggy♦ Jan 24 '11 at 21:21
I got curious and googled a little bit: social.answers.microsoft.com/Forums/en-US/excelchart/thread/… – molgar Feb 21 '11 at 16:57
feedback

3 Answers

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

link|improve this answer
Post the URL to the image you uploaded to imgur, if necessary using hxxp or otherwise obfuscating the URL. Other users with the appropriate privileges can then edit your post and add the image based on the URL. Because I commented on your post, you can add another comment to it, and addressed to @Daniel. I'll get notified of your comment and will then edit your answer. – Daniel Beck Feb 14 '11 at 18:15
@Daniel thanks - the image is here – Anthony Crowson Feb 14 '11 at 21:38
Awesome! I gave this up as a lost cause! – Patrick Feb 17 '11 at 21:49
feedback
up vote 2 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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