CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES EACH DAY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julia - 25 Jul 2007 15:26 GMT

How do i show the change in direction of the wind against an inanimate object
over the course of a week?

I expect it to be a circle with the inanimate object represented in the
centre and lines showing relative wind direction from each degree point for
each day.

Reply to this Message

Bernard Liengme - 25 Jul 2007 16:03 GMT

Some hypothetical data
day angle
mon 45
tue 150
wed 60
thu 30
fri 90
sat 100
sun 72

0 0
0.707107 0.707107

0 0
0.5 -0.86603

The 0,0 is the origin of the vector
The .707 come from =SIN(RADIANS(A2) )and =COS(RADIANS(B2))

Make an Xy plot of this data.
The block of data is for day 2; copy with the chart selected and use Edit |
Paste Special>New Series

Repeat for others days
Make Max and Min both axis equal to 1 and remove the axis labels.

Hope you like the result.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> How do i show the change in direction of the wind against an inanimate
> object
[quoted text clipped - 4 lines]
> for
> each day.

Reply to this Message

Del Cotter - 25 Jul 2007 16:04 GMT

>How do i show the change in direction of the wind against an inanimate object
>over the course of a week?
>
>I expect it to be a circle with the inanimate object represented in the
>centre and lines showing relative wind direction from each degree point for
>each day.

I believe that's known as a "wind rose" chart. Have you googled "excel
wind-rose"? There appear to be a number of Excel add-ins for this.

Ed Ferrero has something called a windrose, but it's not the same, just
a nice-looking picture with a couple of arrows.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message