Wind Rose Diagram Info

A wind rose diagram is a tool which graphically displays wind speed and wind direction at a particular location over a period of time. The diagrams normally comprises of 8 or 16 radiating spokes, which represent wind directions in terms of the cardinal wind directions (North East South West) and their intermediate directions.

Meteorologist use wind rose diagrams to summarise the distribution of wind speed and direction over a defined observation period. Data is taken from a weather station, which should be a near as possible to your project /site. Click here to find an appropriate weather station.

What do the Spokes Represent?

Each ‘Spoke’ shows:

  1. How often the wind blows from each direction
  2. How often the wind blows at each pre-defined wind speed bins (shown by the colour bands) for each wind direction


A wind rose diagram uses a polar coordinate system, whereby data is plotted a certain distance away from the origin at an angle relative to north. It is possible to create these plots using costly purpose-made software or, alternatively, very basic wind rose diagrams can be made using Microsoft Excel (see here). Wind Rose Excel intends to form a half way solution: a means to produce wind rose plots which are professional and informative, while also ensuring providing excellent value.

Interpreting a Wind Rose

Diagram 1 - Interpretation of a wind rose spoke

In Diagram 1 the westerly spoke and its colour bands provides the following information:

  • The wind blows from the west (a “westerly”) 12% of the time at location x
  • Westerly wind speed distribution for location x:
    • 1% of total time the wind blows at 0-2 knots from the west
    • 1% of total time the wind blows at 2-3 knots from the west
    • 1.5% of total time the wind blows at 4-6 knots from the west
    • 3.5% of total time the wind blows at 7-10 knots from the west
    • 3% of total time the wind blows at 11-66 knots from the west
    • 1% of total time the wind blows at 17-22 knots from the west
    • 1% of total time the wind blows at >23 knots from the west




What is Possible using Excel?

Example of wind rose diagram created in excel

Diagram 2: Wind rose diagram created using Microsoft Excel

When presented with the data required to make a wind rose, the best excel can do is produce a radar plot as shown by Diagram 2. It is worth noting that it takes considerable time to create a wind rose in excel. We estimate that it will take an experienced excel user between 2 and 3 hours to create a wind rose as shown in Diagram 2. This is because the data needs to be adjusted in various ways to enable the “Filled Radar Plot” to accurately present the data.

It is not possible to create the radial ‘spokes’ that are industry standard for wind rose diagrams. In order to produce spokes, WRE v1.4 is uses VBA coding. The code also automated the process of creating the wind rose plots, saving considerable time.

What is Possible using WRE v1.4?

  • The software transforms the layout of the standard excel radar plot into a succinct graphical design.
  • The diagrams have correctly labelled radial guide lines and spokes, adding credibility to your report writing.
  • The time taken to produce each diagram is reduced to a matter of minutes
  • Included in the new WRE 1.4 package is a data sorting tool. This will guide you through the process of sorting your data into wind speed bins and wind directions (see more info here).
  • We have been selling Wind Rose software for the last 5 years. We are able to answer any questions you have in our support forum once you have purchased the software.
  • We provide the most complete, cost-effective solution on the market.


Forming relative frequencies

How to Create a Wind Rose Diagram using Microsoft Excel

Using Excel to make a Wind Rose – A step-by-step guide It is possible to make a wind rose (of sorts) by using excel only. You will end up with a plot looking like the example given below: The process is fairly long and tricky, and the end result is not the professional Wind Rose …

View page »

Featured Image

Wind Rose Data

Wind Speed Data from Global Weather Stations This page is dedicated to listing as many publicly-available wind speed data sources as possible. Over the coming weeks we will be providing link to as many different sources of wind speed data as possible. In the near future, we aim to offer our visitors a detailed directory of …

View page »

Wind Kinetic Energy Explanation

Wind Speed Vs Wind Power

Kinetic Energy In order to quantify the power available in the wind we need to consider kinetic energy. Therefore, we need to understand how kinetic energy in atmospheric wind is calculated (see equation below). The mass of wind In order to calculate the mass of air colliding with the swept area of a wind turbine per unit …

View page »