Building 3 axis chart.

[Guest]

I am trying to build a chart that has 3 axis. Such as x-axis, y-axis, z-axis.

I want to put 3 different data for these 3 axis; such as: time data, profit
data, phone call data.

Could anyone tell me how to do it?

Thanks in advance,
Erol

 

[David Biddulph]

Have you tried a 3-D surface chart? Beware, of course, of the fact that
viewing 3D data on a 2D display can sometimes be confusing.

 

[Guest]

Jon Peltier has an example of how to create a third axis on his site . . .
hopefully this will help.

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

 

[Jon Peltier]

The tertiary axis is not a third orthogonal axis, and in general it's not
very effective in terms of understanding the data.

That can be said about 3D charts, as well: in general they are not very
effective in terms of presenting understandable data.

Excel has no native 3D x-y-z charts, and any renderings of 3D objects on a
2D medium (paper or computer screen) is going to be difficult to read
accurately.

- Jon