3D wire mesh surface chart.

[bobby]

Hi everybody,


I need help of this forum people to draw a 3D chart. I
have fixed values on X&Y axis and variable values on Y-axis. I think
its beetr to give an example rather than confusing. Here I'm giving the
example

X Y1 y2 y3 y4 z1 z2 z3
z4

13.10 3 5 7 9 38 41 37
42
13.20 3 5 7 9 52 47 51
47
13.30 3 5 7 9 66 54 56
64
....
.....
....
....
so on .

Could any body help me out to do this chart taht appears in 3D wire
mesh.

Thanks and Regards

Booby

 

[David Biddulph]

Insert/ Chart/ Surface...

 

[Jon Peltier]

You need to arrange your data properly. The top row should contain each Y
value and the left column each X value (with the top left cell being blank).
The Z values go into the appropriate cell, defined by an X and a Y value.
Then create the chart. See this article for more details:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

- Jon

 

[Mike Middleton]

bobby or Booby -

You will have to rearrange your data values to create a 3D surface chart.

Before you proceed, I strongly recommend that you read Jon Peltier's article
at

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

- Mike
http://www.mikemiddleton.com

 

[bobby]

Hi,

A lot of Thanks to all of you Now I'm working on that.

Regards

Ramana