ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how to get three axes on a graph? (https://www.excelbanter.com/charts-charting-excel/173127-how-get-three-axes-graph.html)

michellelav

how to get three axes on a graph?
 
As in x y and z!

Bernard Liengme

how to get three axes on a graph?
 
You need to make a 'surface chart'
But be aware that the values are treated as categories (as in a Line chart)
not as values (as in an XY chart)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"michellelav" wrote in message
...
As in x y and z!




ShaneDevenshire

how to get three axes on a graph?
 
Hi,

Surface plots are really not that hot in Excel although you can make them
interesting if you use enough data points. Alternatively, you might consider
a 3-D Column chart or 3-D Line chart, each of which is the last choice in
their category sub-type areas on step 1 of the wizard. (2003)

--
Cheers,
Shane Devenshire


"michellelav" wrote:

As in x y and z!



All times are GMT +1. The time now is 05:24 PM.

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