making a chart with an x, y and Z axis

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 13, 2002

• #2

I think you mean two y axes.

Select the series you want to plot on the second y axis, right click and choose Format Data Series. On the Axis tab select Secondary Axis and click OK.

 

Upvote 0

B

bellgirl

New Member

Joined

Jul 15, 2002

Messages

38

• Aug 13, 2002

• #3

Thank you for your reply, but no, I mean a 3-axis graph with a x-axis, a y-axis and a z-axis. Is excel capable of making a 3-axis graph? Thanks!

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 13, 2002

• #4

Where would you expect to see the z axis?

 

Upvote 0

B

bellgirl

New Member

Joined

Jul 15, 2002

Messages

38

• Aug 13, 2002

• #5

The z-axis would be coming out of the page. It would be a 3D graph.
Any ideas?
Thanks!

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 13, 2002

• #6

You can do 3D column or line charts. Select your chart and choose Chart, Chart Type from the menu. Choose Column or Line and the last one in the Chart sub-type window.

 

Upvote 0

B

bellgirl

New Member

Joined

Jul 15, 2002

Messages

38

• Aug 13, 2002

• #7

The problem with doing that is that the graph still only has 2-axis, x and y. I have 3 sets of data I would like to plot together and therefore I need to create a 3-axis graph.

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 13, 2002

• #8

It has 3 axes. The z axis gives Series1, Series 2 etc.

Why not post some data and explain what you want to see in the chart?

 

Upvote 0

B

bellgirl

New Member

Joined

Jul 15, 2002

Messages

38

• Aug 13, 2002

• #9

I hope I can explain this so that it makes sense. here is a sample of my data:
X______ Y______ Z_________
5______ 1______ 48.3189333
10_____ 1______ 40.40369468
15_____ 1______ 44.52716888
5______ 0.9____ 29.77774948
10_____ 0.9____ 31.40946542
15_____ 0.9____ 34.22632184
5______ 0.8____ 19.50047199
10_____ 0.8____ 20.94893318
15_____ 0.8____ 23.86645134
I have an equation with x,y and z in it. I want to have x=5,10,15,20...60 and y=1 to find the cooresponding z values. Then I will have x=5,10,15,20...60 again and y=.9 to find the cooresponding z values. I repeat this for y=.8,.7,.6, and .5. I would like my y-axis to range from .5-1 and my x-axis range from 5-60.
Thanks!
This message was edited by bellgirl on 2002-08-13 09:52
This message was edited by bellgirl on 2002-08-13 09:54

 

Upvote 0

D

dbrb2

New Member

Joined

Aug 11, 2002

Messages

30

• Aug 13, 2002

• #10

To do this, you need to se your data out in 'a cross' shape :
zzzzzzzzyzzzzzzzzz
zzzzzzzzyzzzzzzzzz
zzzzzzzzyzzzzzzzzz
xxxxxxxxxxxxxxxxxx
zzzzzzzzyzzzzzzzzz
zzzzzzzzyzzzzzzzzz
zzzzzzzzyzzzzzzzzz

Where the z values are those relating to the
x value in that column and the y value in that row. To Plot the graph, select the lot
and select surface plot, and voila. If what you want to do is plot 3d mathematical functions however, there are some very nice javascript plotters on the web. hope this works ...

Ben

 

Upvote 0