Using Excel to Create Wind Rose

[alan6017518]

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!!!

[gavinkelly]

Your link does not work.

[alan6017518]

Here is the link:

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

[Kenneth Hobson]

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
and http://addictedtor.free.fr/graphique....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

[alan6017518]

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~~

[alan6017518]

Here is the image's link:

http://img.photobucket.com/albums/v4...aCherub/-1.png

[Tom Schreiner]

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