ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   X and Y axis - Sure! Use a X axis? Hmmm (https://www.excelbanter.com/excel-discussion-misc-queries/11236-x-y-axis-sure-use-x-axis-hmmm.html)

SS

X and Y axis - Sure! Use a X axis? Hmmm
 
How do I create a graph that uses X, Y and Z axes?

Andy Pope

Hi,

Excel does not, as standard, do 3 value dimension charts.

Have a read of Tushar's page on 3d surface charts.
http://tushar-mehta.com/excel/charts...ace/index.html

You can fake a 3d plot using formula. Check out Fernando Cinquegrani's
example.
http://www.prodomosua.it/ppage02.html

Or my own version.
http://www.andypope.info/charts/3drotate.htm

Cheers
Andy

SS wrote:
How do I create a graph that uses X, Y and Z axes?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 06:20 PM.

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