want a 3d surface graph that..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, want to make a 3d surface graph that will take data from three column
row on the x axi
column on the y axi
and value on the z axi

the closest that I can make expects data to be in a grid of rows and columns and assumes x and y is the number of rows and columns

My data would look like thi
Xcoord Ycoord Zcoor
255 500 18
254 501 20
255 501 48
256 501 18
253 502 10
254 502 40
255 502 102
256 502 35
257 502 8
254 503 22
255 503 50
256 503 20
255 504 14
254 504 11
255 505 5
fiverows by five columns
any help is appreciated
(e-mail address removed)
 
XL's 3D charting capability is rather limited. You will have to have
the data in a tabular format that XL expects. In addition, the x and y
axis are not real numerical axis, but what XL calls category axis.

To simulate a 3D chart, check out Andy Pope's suggestion at
http://www.andypope.info/charts/3drotate.htm

Alternatively, consider a commercial package. Some choices include:
http://www.google.com/groups?selm=MPG.1710f373ed45532a98a5ad%
40msnews.microsoft.com
--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Martin -

Use a pivot table to turn your columns into a grid:

Z-avg Xcoord
Ycoord 253 254 255 256 257
500 186
501 200 489 180
502 100 400 1024 350 87
503 220 500 200
504 110 145
505 50

Copy this, paste the values into another range, and put zeros into all
the blank cells. Now make your surface chart.

- Jon
 
Unfortunatly the real data is 659 rows and 494 columns
excel wont suport that big a width and copy and pasting is not
practical

I hope MS reads the 3d posts and start improving excel.
 
Back
Top