bbuggeln
Had this question 9
Question
bbuggeln asked on
| 12577 views

Does anyone know of a way to do a wind rose in excel or have any custom code to generate one?

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.

Any ideas?

Thanks a lot!

b

Herbert Seidenberg
Found this helpful 2
Answer
Herbert Seidenberg replied on

Reply

Bernard Liengme
Found this helpful 0
Bernard Liengme replied on
MVP

Have your tried to Google with "Excel wind rose"? If found this app which lets you export the result into Excel

http://www.softpedia.com/get/Science-CAD/WindRose-PRO.shtml

best wishes


Bernard Liengme, Nova Scotia, Canada http://people.stfx.ca/bliengme/
http://people.stfx.ca/bliengme
A Guide to MS Excel 2007 for Scientists and Engineers
bbuggeln
Found this helpful 0
bbuggeln replied on

Reply

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...

Herbert Seidenberg
Found this helpful 1
Herbert Seidenberg replied on
Excel 2007/2010 PivotTable, Table
Radar Chart as Wind Rose
All within Excel
http://c0718892.cdn.cloudfiles.rackspacecloud.com/09_17_10.xlsx
Pdf preview:
http://www.mediafire.com/file/y783bak99m7kimd/09_17_10.pdf

bbuggeln
Found this helpful 0
bbuggeln replied on

Reply

I was really hoping for a bar chart version of that, as seen here:

http://en.wikipedia.org/wiki/File:Wind_rose_plot.jpg
Herbert Seidenberg
Found this helpful 2
Answer
Herbert Seidenberg replied on

Reply

Hassan El-Meligy, MSc
Found this helpful 0
Hassan El-Meligy, MSc replied on

Reply

When I download the PDF it is ok

When I download the xlsx it gives a ZIP file ??

Business Information and Infrastructure Architect.
JLLatham
Found this helpful 1
JLLatham replied on

Reply

Try simply changing the .zip to .xlsx and see if it will open in Excel 2007 or 2010.  .xlsx and .xlsm files actually ARE zipped files with several folders and files within them. 
I am free because I know that I alone am morally responsible for everything I do. R.A. Heinlein
I am free because I know that I alone am morally responsible for everything I do. R.A. Heinlein
davros_abers
Found this helpful 1
davros_abers replied on

Reply

Excel 2007/2010 Radar Chart/Wind Rose
With bars.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/09_17_10.xlsx
Pdf preview:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/09_17_10a.pdf

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!

Many thanks, 

Dave

Herbert Seidenberg
Found this helpful 0
Herbert Seidenberg replied on

Reply

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.

davros_abers
Found this helpful 0
davros_abers replied on

Reply

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?

Cheers

Previous Previous Page of 3 Next Next