Excel - Building 3 axis chart.

Asked By Erol Peku on 04-Nov-07 01:46 AM
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 replied on 04-Nov-07 04:42 AM
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.
--
David Biddulph
JohnMansfiel replied on 04-Nov-07 11:26 AM
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

--
John Mansfield
http://cellmatrix.net
Jon Peltier replied on 04-Nov-07 03:25 PM
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______