how do I plot on the z axis?

[banderson]

I want to do a 3 axis scatter plot. Is there a way to do this? Thanks in
advance,

Brad

 

[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/3d_surface/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

 

[banderson]

Andy,

Thanks for the help.

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/3d_surface/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