Contour Maps form Excel Charts

  • Thread starter Thread starter Jim Fullton
  • Start date Start date
J

Jim Fullton

I thought that it would be simple but apparently not. I am trying to create a
contour map from XYZ data points. I am using Excel 2003. I tried the surface
plot examples but can't seem to make sence of it. Can someone give me a
little help? Here is a small set of the data I'm working with:

x y z
2640352 518926 8.4
2639055 519367 13.3
2639573 518721 8.2
2639366 520081 8.8
2639451 520542 16.6
2638851 519372 15.3
2638037 519521 12.3
2637360 519641 9.7
2638856 520656 18.2
2640153 519128 16.4
2640446 519059 9.7
2639092 519853 16.5
2638825 519707 15.4
2638830 519705 12.5
2640008 519404 10.7
2640272 519479 16.2
2640326 519368 14.5
2640489 519260 15.8
2640552 519450 13.2
2640090 519610 11.6
2639962 519228 12.4
2639900 519038 12.7
2639826 518848 5.7
2640236 519133 14.2
2640188 518944 5.3
2640110 518753 6.0
2639131 519923 11.4
2639068 519733 9.5
2639007 519543 12.1
 
Jim Fullton -

Use Excel's online Help to search for "Creating a Surface chart."

Or, browse directly to
http://office.microsoft.com/en-us/excel/HA011179391033.aspx?pid=CL100570551033

For a Surface chart, the X and Y axes are category (labels) axes, so the
text values are displayed equally-spaced. Therefore, to avoid distortion,
the numerical values for the X and Y axes must be equally-spaced.

And, the data must be arranged in a rectangular range with X labels in a row
at the top, Y labels in a column on the left, and Z numerical values in the
intersection cells of the range.

If you leave the top left cell empty and select that cell along with the X
labels, the Y labels, and the Z values, Excel will guess correctly and
create the Surface chart.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
Jim Fullton said:
I thought that it would be simple but apparently not. I am trying to create
a
contour map from XYZ data points. I am using Excel 2003. I tried the
surface
plot examples but can't seem to make sence of it. Can someone give me a
little help? Here is a small set of the data I'm working with:
Click to expand...

[excel2003]
http://www.prodomosua.eu/zips/srfchart.xls
if you need information on how to select options
download and install contours.xlt from
http://www.prodomosua.eu/ppage02.html
.f
 
Back
Top