CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES EACH DAY

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
Click to expand...

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