3D Surface from data from 3 columns

[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

 

[Frank Kabel]

Hi Jack
have a look at
http://www.tushar-mehta.com/excel/charts/3d_surface/index.html

Frank

 

[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

 

[Jon Peltier]

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

 

[jack]

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.

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.

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

 

[Jon Peltier]

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

 

[jack]

Thank you soooo much

Jack

 

[JustLiberty]

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.