Make Geographic maps Using Excel

[Philly2034]

Question 1
The longitudes are across the 1st row. The latitudes are in column A. The values of my dataset are in the intersections of these. How would I create a contour map of this on the earth?

	A	B	C
1		-80	-70
2	40	5.3	18.6
3	30	17.9	20.2

<tbody>
</tbody>

---------------------------------------------------------------------------------------------------------

Question 2
The longitudes are in column A. the latitudes are in column B, across each row is the value of my data set. How would I create a contour map of this on the earth?

	A	B	C
1	-77	30	2.34
2	-88	25	3.45
3	-79	20	6.75
4	-90	31	1.09

<tbody>
</tbody>

-----------------------------------------------------------------------------------------------------

Question 3
The following spreadsheets are in R1C1 reference style. The longitudes are across the 1st row. The latitudes are in column A. The first spreadsheet is for time 0. The second spreadsheet is for time 1. How would I create an animation of this?

	1	2	3
1		-80	-70
2	40	5.3	18.6
3	30	17.9	20.2

<tbody>
</tbody>

	1	2	3
1		-80	-70
2	40	6.7	19.1
3	30	8.9	15.6

<tbody>
</tbody>

 

[Philly2034]

I have found a spreadsheet program called "teapot."
This program is 3 dimensional, but it does not do the graphing that I would like.

 

[Philly2034]

I have found a mapping website called batchgeo. This program lets you plot points for my Question 2, but it does not isoline.