If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES 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. |
Thread Tools | |
Display Modes | |
|
|