I want to plot 3D (X,Y,Z) points in excel, similar to and XY Scatter but with a third axis. The surface graph type does not do what I want because it is not able to plot scaled numerical values on 2 of 3 axis. Does anyone know how I can do this.
Printable View
I want to plot 3D (X,Y,Z) points in excel, similar to and XY Scatter but with a third axis. The surface graph type does not do what I want because it is not able to plot scaled numerical values on 2 of 3 axis. Does anyone know how I can do this.
Hi,
Since my problem is very similar/related to this I didnt open a new thread but I am continuing here. As explained I did a 3D excel chart and everything is OK. I just want to go a step further and find a way to automatically adjust the minimum and maximum axis/cage data values to those which will be actually plotted. For example: I have data plotted those x,y,z values can be 500 or 5000. And since my cage/axis data is predefined to a fixed value (to accommodate bigger data), small data doesn't look good in plot.