ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Radar Plot using geographical coordinates (https://www.excelbanter.com/charts-charting-excel/28869-radar-plot-using-geographical-coordinates.html)

David

Radar Plot using geographical coordinates
 
I am trying to generate a circular radar or XY scatter point plot using
geographical coordinates referenced to a tower in the aproximate center
(with its own geographical coordinates and the plotted data in 4 quadrants
(+X/+Y, -X/+Y, -X/-Y and +X/-Y) in order to plot the RF field strength of an
FM broadcast station.

I have 5 columns of data:
1 the Latitude coordinates of the tower for center reference.
2 the Longitude coordinates of the tower for center reference.
3 the Latitude coordinates where I took the measurements.
4 the Longitude coordinates where I took the measurements.
5 The RF field strength at the aforementioned coordinates .

I would really appreciate any help with this as it has been quite a few
decades since I have tried Cartisian Co-ordinates, or rectangular to polar
conversions and such. What's left of my brain is starting to get foggy!!!

Dave Whitehead




Tushar Mehta

Check the responses to your last post. If you've already read them and
found them lacking you might want to explain how. Simply repeating
your original post doesn't serve much useful purpose.

--
Regards,

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

In article , dlw0
@sbcglobal.net says...
I am trying to generate a circular radar or XY scatter point plot using
geographical coordinates referenced to a tower in the aproximate center
(with its own geographical coordinates and the plotted data in 4 quadrants
(+X/+Y, -X/+Y, -X/-Y and +X/-Y) in order to plot the RF field strength of an
FM broadcast station.

I have 5 columns of data:
1 the Latitude coordinates of the tower for center reference.
2 the Longitude coordinates of the tower for center reference.
3 the Latitude coordinates where I took the measurements.
4 the Longitude coordinates where I took the measurements.
5 The RF field strength at the aforementioned coordinates .

I would really appreciate any help with this as it has been quite a few
decades since I have tried Cartisian Co-ordinates, or rectangular to polar
conversions and such. What's left of my brain is starting to get foggy!!!

Dave Whitehead






All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com