3-D Graphing

[Guest]

I would very much like to plot X-Y-Z data (e.g. depth vs. x,y coordinates) in
3-D. Just wondering if it's even possible with the Excel graphing functions.

 

[Jon Peltier]

If the X,Y coordinates are defined by a regular grid, arrange the data like this:

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

The top left cell is best kept blank. Select the range, and choose a surface or
contour chart in the Chart Wizard.

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

 

[Tushar Mehta]

3D charting is possible only in limited conditions. For a tutorial on
the subject see
3D Surface
http://www.tushar-mehta.com/excel/charts/3d_surface/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

 

[Guest]

I've looked for "contouring" in XL graphs for a long time and they don't exist.
However, this Italian website has a spreadsheet that does contour.
How, I don't know.

http://www.prodomosua.it/ppage02.html