Wind rose chart

[Milos]

Hello,

I am just wandering if anybody has done a windrose chart in Excel. Rather
than trying to explain it, here is a good example.

http://www.wxnet.com/images/windrose.gif

Thank you in anticipation.

Milos.

[Andy Pope]

Milos,

You can use the radar chart, with filled series, to get very close to
the example you have given.

Although you will have to;
1. add additional points to give you spacing between the compass points
2. perform calculations on your data to simulate stacked series
3. add additional data series to handle gridlines

If you require a worked example let me know.

Cheers
Andy