ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I create a 3 dimensional plot, for example XYZ scatter plo. (https://www.excelbanter.com/charts-charting-excel/10474-how-do-i-create-3-dimensional-plot-example-xyz-scatter-plo.html)

pleasehelp

how do I create a 3 dimensional plot, for example XYZ scatter plo.
 
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...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

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


--

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


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

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