3D Surface from data from 3 columns

  • Thread starter Thread starter jack
  • Start date Start date
J

jack

introduction:
I need 3D surface chart made in Excel.

I have data written in 3 columns lets say A,B,C
I think that I need to convert them to table to make the chart (A would be
horizontal axis, B- vertical and C- values)- but I do not know how to do it
:-(

Could you please help me? :-)

Jack
 
Thank you very much :-) but...
The example shows how to make 3d surface chart using function...
but what I really need to know is:
How to make a 3d surface chart from data written in columns like:

1 3 4
2 6 7
5 6 7
4 8 9
5 6 7
12 4 67
....

Jack
 
Jack -

Excel doesn't support XYZ surface charts. You can fake an XYZ scatter
chart: see Andy Pope's web site for a sample file that shows the trig
functions in action (http://andypope.info).

If you have data that would fit into a grid of rows and columns, one
value per grid location, no grid locations without a value, you can make
a surface chart in Excel. If you have X-Y-Z in columns, but the
requirements I just stated are met, you can use a pivot table to turn
your list into a grid. Put headers on the columns (X, Y, and Z will do),
put X in the rows field, Y in the columns field, and Z in the data
field. Make your surface chart from the resulting table.

- Jon
 
If you have data that would fit into a grid of rows and columns, one
value per grid location, no grid locations without a value, you can make
a surface chart in Excel. If you have X-Y-Z in columns, but the
requirements I just stated are met, you can use a pivot table to turn
your list into a grid.
Click to expand...
but how exactly should I do it?



Put headers on the columns (X, Y, and Z will do),
put X in the rows field, Y in the columns field, and Z in the data
field. Make your surface chart from the resulting table.
Click to expand...
it is very easy but it doesn't change my XYZ into grid...:-)

I am not a newbie- but I still don't know how to do it...:-)


Jack :-)
 
Select your data, then choose Pivot Table from the Data menu. While
defining the layout of the pivot table (different versions of Excel
handle this differently), drag the X field into the rows area of the
layout, drag the Y field into the columns area, and drag the X field
into the data area. This should produce a grid of rows and columns that
can be used as the source of a surface chart. Assuming there is a unique
Z value for each X-Y pair.

- Jon
 
FYI, In order to "select the list" and get the Pivot Table to use it, the list must be contiguous: X,Y,Z must be in adjacent columns.
 
Back
Top