Create wind rose from the data in excel

Hello All,

I am trying to create a wind rose in excel. IS there a process to make wind rose in excel ? Would you please give any suggestions ?

How's this?

Cumulative values from bottom up; filled radar chart.

Okay, so looking at it again, I got the bands in the wrong order, but you get the idea.

That's what you get for rushing it because your dinner's ready!

I had a good search around and found instructions on this site:

http://www.energygarden.co.uk/

Unfortunately you have to pay, but its only 99p.
Final wind rose website 2.jpg

Here's another link, with a file (and instructions) from Herbert Seidenberg:

http://answers.microsoft.com/en-us/o...8-785a4709d4e8

Hope this helps.

Pete