ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Building 3 axis chart. (https://www.excelbanter.com/charts-charting-excel/164693-building-3-axis-chart.html)

Erol Pekuz

Building 3 axis chart.
 
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[_2_]

Building 3 axis chart.
 
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

"Erol Pekuz" <Erol wrote in message
...
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




John Mansfield

Building 3 axis chart.
 
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





"Erol Pekuz" wrote:

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


Jon Peltier

Building 3 axis chart.
 
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
_______


"John Mansfield" wrote in message
...
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





"Erol Pekuz" wrote:

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





All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com