Results 1 to 7 of 7

Using Excel to Create Wind Rose

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

  1. #1
    New Member
    Join Date
    May 2008
    Posts
    12

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

  2. #2
    Board Regular
    Join Date
    Jan 2008
    Posts
    221

    Default Re: Using Excel to Create Wind Rose

    Your link does not work.

  3. #3
    New Member
    Join Date
    May 2008
    Posts
    12

    Default Re: Using Excel to Create Wind Rose


  4. #4
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    1,664

    Default Re: Using Excel to Create Wind Rose

    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
    Last edited by Kenneth Hobson; Aug 26th, 2008 at 02:01 PM.

  5. #5
    New Member
    Join Date
    May 2008
    Posts
    12

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

  6. #6
    New Member
    Join Date
    May 2008
    Posts
    12

    Default Re: Using Excel to Create Wind Rose


  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824

    Default Re: Using Excel to Create Wind Rose

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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com