Your link does not work.
This is a discussion on Using Excel to Create Wind Rose within the Excel Questions forums, part of the Question Forums category; 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 ...
I'm trying to make a wind rose like this:
Does anyone know how to write a VB to create a wind rose like this?
Thanks a lot!!!
Your link does not work.
Here is the link:
Here is an add-on: http://www.cres.gr/windrose/joomla/index.php
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
Last edited by Kenneth Hobson; Aug 26th, 2008 at 02:01 PM.
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~~
Here is the image's link:
Alan. Have you made any attempt at all? Please post any code you have come up with...
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/
- Have your data listed in 2 columns: 1 for mean wind speed and 1 for wind direction
- Insert a PivotTable
- Drag the Mean Wind Speed field into the ‘COLUMNS’
- Drag the wind direction field into the ‘ROWS’
- Drag the Mean Wind Speed field into the ‘∑ VALUES’
- Drag the new Row Labels into the correct order, I.e. N, NNE, NE, ENE
- Display the data as Relative Frequencies using the Countif function
- Grouping the Column Labels (Wind Speed) into bins
- 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!