Making Wind Rose in Excel!!

[ckmoied]

Hi all,

I have some data on wind speed and wind direction, in Excel worksheets.

I want to develop the wind roses for this data using excel charts. Does anybody have an idea about how to do it.

Have a nice day.

 

[RalphA]

Please post an actual example of data and the result you would like!!!

 

[ckmoied]

Suppose follwing data is in col A. where 0 or 360 represent north direction. 90=East, 180=South, and 270=West. Now the data once plotted must appear as a wind rose.

There are softwares which can produce wind rose charts. However I want to generate them using Excel Charts.

102.24
109.55
111.49
149.39
144.53
134.59
147.49
96.61
100.97
125.51
101.47
118.97
115.07
93.06
99.24
108.5
104.32
205.33
310.13
327.73
348.11
350.7
349.32
334.41
396.88
395.33
352.37
258.25

 

[fairwinds]

Maybe this can get you a bit on the way...?
As I could not manage with chart I put your directions in column A (but changed so no one is more than 360 degrees) and put some wind speeds in column B
and run this:

Sub XXX()
     
    a = 2
    Do While Cells(a, 1) <> ""
    ActiveSheet.Shapes.AddShape(msoShapeUpArrow, 177#, 104, 20, 10). _
        Select
    Selection.ShapeRange.IncrementRotation Cells(a, 1)
    Selection.ShapeRange.ScaleHeight Cells(a, 2), msoFalse, msoScaleFromBottomRight
    a = a + 1
    Loop
    
End Sub