View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
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?