How do I create a Contour Graph in excel with x, y and z data?

G

Guest

I have a set of x, y and z data. I want to display this data as a countour
graph. How do I do this in excel?
 
J

Jon Peltier

You can't get a true X-Y-Z contour chart; Excel's contour chart is pretty rudimentary.

Set up your data like this:

Y1 Y2 Y3 Y4
X1 Z11 Z12 Z13 Z14
X2 Z21 Z22 Z23 Z24
X3 Z31 Z32 Z33 Z34
X4 Z41 Z42 Z43 Z44

The top left cell should be blank. Select the range and start the chart wizard.

I've found that the shape of the contour chart is not very good, particularly if you have saddle
points. Say two diagonally opposed points have high values of 5 and the other two have low
values of 1. A true rendering of the saddle point would give you a value around 3 in the middle,
but Excel draws a straight line at 5 connecting the two high points, then slopes the sides down
to 1. The effect is more of a rooftop than a saddle.

If I really need this kind of chart, I insert a row between each row of data, and a column
between each column of data, then use formulas or eyeball to interpolate the values of these
inserted cells. A lot of work for so-so results.

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

senselessticker

Is there a way to label the contour line values on the chart itself
rather than a legend?

Thanks,

Sense...
 
J

Jon Peltier

Contour charts don't support data labels or combination charts. Your only possibility is to make
labels using text boxes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Joined
Aug 20, 2012
Messages
7
Reaction score
0
To create a contour plot with contour lines in Excel, try Contour Plot at Office Expander dot com
There is a demo version to try.
Cheers.
 

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

Top