Using Excel to Create Wind Rose

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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-CAD/WindRose-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/graphiques/RGraphGallery.php?graph=97
and http://addictedtor.free.fr/graphiques/RGraphGallery.php?graph=123

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:
Upvote 0
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~~
 
Upvote 0
Alan. Have you made any attempt at all? Please post any code you have come up with...
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top