Using Excel to Create Wind Rose

G

gavinkelly

Board Regular

Joined

Jan 12, 2008

Messages

220

• Aug 26, 2008

• #2

Your link does not work.

 

Upvote 0

A

alan6017518

New Member

Joined

May 19, 2008

Messages

12

• Aug 26, 2008

• #3

Here is the link:

http://picasaweb.google.com/michelle.hys/Work

 

Upvote 0

Kenneth Hobson

Well-known Member

Joined

Feb 6, 2007

Messages

3,183

Office Version

1. 365

Platform

1. Windows

• Aug 26, 2008

• #4

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: Aug 26, 2008

Upvote 0

A

alan6017518

New Member

Joined

May 19, 2008

Messages

12

• Aug 26, 2008

• #5

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

A

alan6017518

New Member

Joined

May 19, 2008

Messages

12

• Aug 26, 2008

• #6

Here is the image's link:

http://img.photobucket.com/albums/v428/lullaCherub/-1.png

 

Upvote 0

L

Legacy 98055

Guest

• Aug 26, 2008

• #7

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

 

Upvote 0

X

xcrider19

New Member

Joined

Feb 26, 2015

Messages

2

• Feb 26, 2015

• #8

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