How to generate a surface with 3 columns

  • Thread starter Thread starter webbug
  • Start date Start date
W

webbug

I have three columns x, y and z
x y z

here z=f(x,y)

Then how to generate a surface chart with x as x-axis, y as y-axis an
z as z-axis

Thanks a lo
 
The way an Excel surface chart works isn't to make unique x-y-z points based on
columns like you have. You need the data laid out in a grid like this:

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

Leave the top left cell of the table blank. Select the range, start the Chart
Wizard, and select the surface type chart.

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