Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Distance calculations | New Users to Excel | |||
how to convert number to bearing .exp. 40.4040 to 40d 40' 40" | Excel Worksheet Functions | |||
Distance between cells | Excel Discussion (Misc queries) | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
Euclidian Distance | Excel Discussion (Misc queries) |