how do I create a 3 dimensional plot, for example XYZ scatter plo.

[Guest]

how do I create a 3 dimensional plot, for example XYZ scatter plot?

 

[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