CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES EACH DAY

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

On Wed, 25 Jul 2007, in microsoft.public.excel.charting,
Julia said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.