How to Make a Wind Rose in Excel: 2 Easy Methods

There are two possible ways to make a wind rose in Excel. We have a dataset of Wind Speed with their Direction for a specific time.

Daraset

Method 1 – Using Recommended Charts

Insert values in the dataset.

Using Recommended Charts Command to make wind rose in Excel

After creating the dataset, select the entire range of the data, then navigate to the Insert tab >> choose Insert Column or Bar Chart>> pick More Column Charts.

Insert chart to make wind rose in Excel

The Insert Chart window appears. Choose Radar from the All Charts tab.
Pick Filled Radar and hit OK.

Note: You can bring the Insert Chart dialog box from any other More Charts option from the Charts group of the Home tab.

A wind rose will be created, as you can see in the image, and you can customize the chart according to your preferences.

Wind rose

Method 2 – Inserting a PivotTable to Make a Wind Rose

Steps:

Select the entire dataset with the CTRL + A key.
Go to the Insert tab, choose PivotTable and select From Table/Range.

Inserting PivotTable to Make a Wind Rose

A PivotTable from table or range window appears.
Check New Worksheet in Choose where you want the PivotTable to be placed.
Hit OK.

Creating Pivot table window

In the PivotTable Fields sidebar, put the Direction in the Columns and in the Values. Drag the Speed in the Rows section.

Convert the Row Labels to Groups. Right-click on any data of the Row Labels and pick Group from the Context Menu.

The Grouping window appears. Uncheck the Starting at and the Ending at boxes. Put the Starting at the value of 0 and Ending at the value of 10 and put the By to 2.
Hit OK.

Grouping window

Right-click on the Speed data, pick Show Values As and choose % of Grand Total from the Context Menu.

Making values as percentage

A PivotTable has been created. Copy the values of the table to create a new dataset.

After pasting the new dataset select the entire range except for the Grand Total row and navigate to the Insert tab, then choose Insert Column or Bar Chart and pick More Column Charts.

Insert Chart to make wind rose in Excel

The Insert Chart window appears. Pick Radar from the All Charts tab.
Hit OK.

A wind rose with the corresponding data has been created, as shown in the image below. You can customize it through the Chart Design as your preference.

Annual wind rose