Using Excel to Create Wind Rose

Thanks:  0
Likes:  0

Thread: Using Excel to Create Wind Rose

1. Using Excel to Create Wind Rose

I'm trying to make a wind rose like this:

http://lh6.ggpht.com/michelle.hys/SL...ind%20rose.png

Does anyone know how to write a VB to create a wind rose like this?

Thanks a lot!!!

4. Re: Using Excel to Create Wind Rose

You might also check out this site: http://www.inl.gov/wind/software/

Here is one article using shapes: http://www.mrexcel.com/archive2/47900/55665.htm

Here is a dedicated program that can import Excel data. It seems reasonable in cost but I would try it first: http://www.softpedia.com/get/Science...Rose-PRO.shtml or http://www.enviroware.com/windrose/help/download.shtml

I would probably use R to plot it since R is free. I does have a steep learning curve. You can marry R and Excel if needed.

For a plot in R of a wind rose see: http://addictedtor.free.fr/graphique...y.php?graph=97

You get R, here: http://cran.r-project.org/

I like to use Tinn-R to develop my R scripts. http://www.sciviews.org/Tinn-R/

Here is another program to do the plots. http://www.ncl.ucar.edu/Applications/rose.shtml

5. Re: Using Excel to Create Wind Rose

I want a wind rose looks similar to the one in the image, so I really need the VB code.

But thx for your help anyway~~

7. Re: Using Excel to Create Wind Rose

Alan. Have you made any attempt at all? Please post any code you have come up with...

8. Re: Using Excel to Create Wind Rose

The best means to start would be to appreciate how the data need to be filtered according to wind direction and wind speed bins:
more images and detail are provided at the following website: http://windroseexcel.com/plotting-wi...ep-step-guide/

1. Have your data listed in 2 columns: 1 for mean wind speed and 1 for wind direction
2. Insert a PivotTable
3. Drag the Mean Wind Speed field into the ‘COLUMNS’
4. Drag the wind direction field into the ‘ROWS’
5. Drag the Mean Wind Speed field into the ‘∑ VALUES’
6. Drag the new Row Labels into the correct order, I.e. N, NNE, NE, ENE
7. Display the data as Relative Frequencies using the Countif function
8. Grouping the Column Labels (Wind Speed) into bins
9. Select the data in the PivotTable and Insert a filled radar plot to view the wind rose thus far!

Hope this helps future people with the same query!

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•