Cannot be done very well with Excel. No direct chart is available. I just read that SPSS has an add-in that you can purchase, but I've never seen it in action.
From Tushar Mehta:
...columns 1 and 2 contain x- and y-
values, each of which is an independent variable. Column 3 contains the
Most 3-D plots I can think of require a surface (since both x and y are
independent variables). Nonetheless, here is how to convert the data provided
into a 3-D 'edge' plot.
Leave the x-values in the column. Convert the y-values into a row (use Cut and
Paste Special... Transpose). Take the z-values and put them in the diagonal of
the table just created. Plot this table as a 3-D graph.
---- y values -----
From Bill Manville:
If your X and Y values are on a regular grid you might get somewhere by making a pivot table from your data, with the first column as column field, the second as row field and the third as data field.
Then you could make a 3-D surface graph from the resulting table
Both of these two are Excel MVPs, so you should be in fine shape, although you shouldn't expect a crystal clear graph as you hoped.