want a 3d surface graph that..

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)
 
T

Tushar Mehta

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
 
J

Jon Peltier

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
 
B

bob

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xyz coordinates graph 1
3D Graph Probs 2
3D column chart with plane / surface added 1
Any ideas for making this graph type easy for other users? 5
Surface Chart Help 1
HELP - surface plots with missing data (How?) 3
graph function 3
How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3

Top