Contour Maps form Excel Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Fullton - 13 May 2008 16:27 GMT

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

Signature

Jim F

Reply to this Message

Mike Middleton - 13 May 2008 23:32 GMT

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

>I thought that it would be simple but apparently not. I am trying to create
>a
[quoted text clipped - 33 lines]
> 2639068 519733 9.5
> 2639007 519543 12.1

Reply to this Message

fernando cinquegrani - 14 May 2008 07:56 GMT

>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:

[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

Reply to this Message

Rate this thread: