Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MJB MJB is offline
external usenet poster
 
Posts: 6
Default charting bearing and distance

I have four columns of information:
1) Latitude of the boat location
2) Longitude of the boat location
3) Distance of an animal from the boat
4) Bearing of the animal from the boat

Basically I have a "whale that is 350 ft at 220 degrees from a boat"

Each location of the animal is recorded with the distance and bearing from
the boat - but the boat remains in the same location

Is there any way to plot that on a chart, ideally with concentric rings of
equal distance values, to show the location of the boat (or even showing the
boat as a central point (lat and long are really not necessary at all) with
the subsequent locations of the animal in relation to that single point?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default charting bearing and distance

Hi,

Sounds like a polar plot.
http://www.andypope.info/charts/polarplot.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"MJB" wrote in message
...
I have four columns of information:
1) Latitude of the boat location
2) Longitude of the boat location
3) Distance of an animal from the boat
4) Bearing of the animal from the boat

Basically I have a "whale that is 350 ft at 220 degrees from a boat"

Each location of the animal is recorded with the distance and bearing from
the boat - but the boat remains in the same location

Is there any way to plot that on a chart, ideally with concentric rings of
equal distance values, to show the location of the boat (or even showing
the
boat as a central point (lat and long are really not necessary at all)
with
the subsequent locations of the animal in relation to that single point?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distance calculations not bright New Users to Excel 6 January 15th 11 04:14 PM
how to convert number to bearing .exp. 40.4040 to 40d 40' 40" melz Excel Worksheet Functions 2 November 22nd 08 11:40 AM
Distance between cells Gary''s Student Excel Discussion (Misc queries) 6 December 3rd 05 03:10 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM
Euclidian Distance Christina Excel Discussion (Misc queries) 5 January 20th 05 04:47 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"