Graphing compass directions

[radiowilson]

I am trying to create weather graphs from the data
gathered by my weather station. Wind direction is recorded
as one of 16 compass points (NE, SSW, ESE, etc.). I need a
method to convert these to compass headings or a way to
chart the directions directly. I have tried the IF/THEN
statements but these seem to be not able to perform the
test 16 times in the one formula. I need this for both
Excel-2000 as well as 2002. Thanks a lot.

 

[Ed Ferrero]

Hi radiowilson,

I am trying to create weather graphs from the data
gathered by my weather station. Wind direction is recorded
as one of 16 compass points (NE, SSW, ESE, etc.). I need a
method to convert these to compass headings or a way to
chart the directions directly. I have tried the IF/THEN
statements but these seem to be not able to perform the
test 16 times in the one formula. I need this for both
Excel-2000 as well as 2002. Thanks a lot.

You are probably better off doing this in VBA. I have
placed a sample file in http://edferrero.m6.net/charting.html
that should do what you want.

 

[Tushar Mehta]

Create a table (17 rows, including one header row and 2 columns) of
compass points and compass headings. Then, use VLOOKUP to convert a
point to a heading.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions