View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES 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 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.