How do I create a topographic map using Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a teacher and need to create a topographic map using Excel?
I can not figure out how to get a third axis. Any suggestions would be more
than helpful.
 
You could make a contour or surface chart. This doesn't work with any X and Y values
you want to include, however. You need regularly spaced X and Y values, categories,
really, and exactly one Z value for each possible X-Y pair. It's pretty
unsatisfactory for a topographical map, unless you generate loads of X and Y values.
The data has to be arranged thus:

Y1 Y2 Y3
X1 Z11 Z12 Z13
X2 Z21 Z22 Z23
X3 Z31 Z32 Z33

The top left cell has to be blank. Run the chart wizard and select the Surface or
Contour type you like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Excel calculate area for 3-D surface charts? 2
True 3D graphics in Excel 1
topographical data maps in excel 1
Insert a Text Filed in Word 2003 2
How to create a bubble chart with more than 2 variables 0
Can't view Google Maps in 3D anymore? Here's the fix. 2
Calculating and Filling a Field Automatically. 1
Column Chart with Dynamix Target Zones 1

Back
Top