Original title: Wind Rose in Excel?
Does anyone know of a way to do a wind rose in excel or have any custom code to generate one?
http://en.wikipedia.org/wiki/File:Wind_rose_plot.jpg is an example of the kind of thing I'm looking for. It's essentially a radar plot, but instead of using lines, it's columns.
Thanks a lot!
Have your tried to Google with "Excel wind rose"? If found this app which lets you export the result into Excel
That's not bad - thanks. I really would prefer it to be witin Excel, if possible.
I've not tried to customize charts or anything, so I don't know how difficult it would be. I was hoping it wouldn't be too difficult to blend the existing bar and radar plots to generate what I was looking for...
I was really hoping for a bar chart version of that, as seen here:http://en.wikipedia.org/wiki/File:Wind_rose_plot.jpg
When I download the PDF it is ok
When I download the xlsx it gives a ZIP file ??
Excel 2007/2010 Radar Chart/Wind Rose
Hi, how do you edit the data and update the chart? Nothing seems to happen when I change any of the values in Table 1. Also, does the speed and direction need to be in a specific format (i.e. degrees and kmph/mph)? Sorry if I'm completely missing the point!
If you still got my randomly changing data in Table1, then
when you refresh the PivotTable, the chart will change radically.
The original cloud file is still there to be downloaded.
Speed and direction can be in any units.
You might have to tweak the grouping size.
Post the desired units and their range.
I didn't realise there was a 'refresh all' button in the pivot table options so it has updated now.
The data I have is:
degrees for the direction. Range 10-360
mph for the speed. Range 0-11
Much of the data are calm days with no wind speed - does this need to be removed?
* Please try a lower page number.
* Please enter only numbers.