RE: Plotting wind speed and direction on a compass?

Lori

unread,

Mar 17, 2008, 12:14:03 PM3/17/08

to

Try an XY chart with straight lines between points. Here's a start...
Choose Insert > Names > Define:

Direction:=Sheet1!$A$2:$A$3
Velocity:=Sheet1!$B$2:$B$3
x: =Velocity*COS(RADIANS(Direction))*{0,1}
y: =Velocity*SIN(RADIANS(Direction))*{0,1}

Edit the chart series formula to show x and y:

=SERIES(,Sheet1!y,Sheet1!x,1)

and remove any gridlines and axes markings.

"WalterKiwi" wrote:

> Hi, I have wind velocity (m/s) and direction (degrees) from a weather station
> and want to plot it with the direction plotted around a 360 degree circle
> (compass?) with the wind represented by an arrow pointing at the appriate
> direction, and it's force by the length of the arrow. Sample data might be
> Direction velocity
> 340 2.1
> 310 5.2
> (and there's date and time data also) Any way to do this? It's hourly data
> for 4 distinct weeks of the year (2 Sept, 2 Nov) for a 5 year period.
> Rgds.
> Walter

WalterKiwi

unread,

Mar 17, 2008, 4:44:11 PM3/17/08

to

Thanks Lori
Trying to do this with excel07, and not having a lot of success. Defined
direction and velocity, defined x and y. selected the series, went to formula
bar to change =series((etc)) and it sits there laughing at me. (well, it does
nothing)
Any hints for Office 2007 sufferers?
Walter

Lori

unread,

Mar 17, 2008, 9:46:00 PM3/17/08

to

I don't have any experience with office 2007 i'm afraid. I would suggest
first creating a scatter using direction and velocity for the x and y values,
then change the source data to refer to "sheet!x" and "sheet!y" where "sheet"
is the sheet name.

Andy Pope

unread,

Mar 19, 2008, 4:34:01 AM3/19/08

to

Hi,

You may find this helpful.
http://www.andypope.info/charts/polarplot2.htm

Or this addin
http://www.andypope.info/charts/polarplot.htm

Do you know of any sites that have examples of the chart look you are after?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"WalterKiwi" <Walte...@discussions.microsoft.com> wrote in message
news:0F7E9725-E20A-4654...@microsoft.com...
> Hi Lori,
> it worked, but it's a bit frustrating - really trying to plot 12 h of
> data,
> but lots of hours the wind comes from the same direction and changing
> "series
> 1" to the appropriate time is no fun. May end up filing this in the "too
> hard basket" for the benefit derived.
> Cheers,
> Walter
>
> "Lori" wrote:
>
>> Try this example:
>> http://www.freefilehosting.net/download/3dib4
>>
>> Insert extra lines inside the data range and the chart lines should
>> update,
>> you need to update the labels manually though.

WalterKiwi

unread,

Mar 18, 2008, 7:26:01 PM3/18/08

to

Hi Lori,
Thanks - this is the type of plot I'm after - Will have a go and see what
happens.. Will let you know.
W

cg

unread,

Nov 11, 2009, 12:31:57 PM11/11/09

to

Lori - I have the same need that you described. Were you able to get your problem figured out? If so, would you mind sharing your workbook?

Much thanks!

WalterKiw wrote:

Hi Lori,it worked, but it's a bit frustrating - really trying to plot 12 h of
18-Mar-08

Hi Lori,
it worked, but it's a bit frustrating - really trying to plot 12 h of data,
but lots of hours the wind comes from the same direction and changing "series
1" to the appropriate time is no fun. May end up filing this in the "too
hard basket" for the benefit derived.
Cheers,
Walter

"Lori" wrote:

Previous Posts In This Thread:

On Sunday, March 16, 2008 8:38 PM
WalterKiw wrote:

Plotting wind speed and direction on a compass?

Hi, I have wind velocity (m/s) and direction (degrees) from a weather station
and want to plot it with the direction plotted around a 360 degree circle
(compass?) with the wind represented by an arrow pointing at the appriate
direction, and it's force by the length of the arrow. Sample data might be
Direction velocity
340 2.1
310 5.2
(and there's date and time data also) Any way to do this? It's hourly data
for 4 distinct weeks of the year (2 Sept, 2 Nov) for a 5 year period.
Rgds.
Walter

On Monday, March 17, 2008 12:14 PM
Lor wrote:

Try an XY chart with straight lines between points. Here's a start...
Try an XY chart with straight lines between points. Here's a start...
Choose Insert > Names > Define:

Direction:=Sheet1!$A$2:$A$3
Velocity:=Sheet1!$B$2:$B$3
x: =Velocity*COS(RADIANS(Direction))*{0,1}
y: =Velocity*SIN(RADIANS(Direction))*{0,1}

Edit the chart series formula to show x and y:

=SERIES(,Sheet1!y,Sheet1!x,1)

and remove any gridlines and axes markings.

"WalterKiwi" wrote:

On Monday, March 17, 2008 4:44 PM
WalterKiw wrote:

Thanks LoriTrying to do this with excel07, and not having a lot of success.

Thanks Lori
Trying to do this with excel07, and not having a lot of success. Defined
direction and velocity, defined x and y. selected the series, went to formula
bar to change =series((etc)) and it sits there laughing at me. (well, it does
nothing)
Any hints for Office 2007 sufferers?
Walter

"Lori" wrote:

On Monday, March 17, 2008 9:46 PM
Lor wrote:

I don't have any experience with office 2007 i'm afraid.
I don't have any experience with office 2007 i'm afraid. I would suggest
first creating a scatter using direction and velocity for the x and y values,
then change the source data to refer to "sheet!x" and "sheet!y" where "sheet"
is the sheet name.