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 SpecialNew 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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Julia" wrote in message
...
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.