CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES EACH DAY

[Guest]

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.

 

[Bernard Liengme]

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

 

[Del Cotter]

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.