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

Insert/ Chart/ Surface...
--
David Biddulph

"bobby" wrote in message
oups.com...
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

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/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"bobby" wrote in message
oups.com...
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

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/P...cle.asp?ID=447

- Mike
http://www.mikemiddleton.com

"bobby" wrote in message
oups.com...
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

Hi,

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

Regards

Ramana


Mike Middleton wrote:
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/P...cle.asp?ID=447

- Mike
http://www.mikemiddleton.com

"bobby" wrote in message
oups.com...
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