How can I create a 3-D scatter plot with 3 axis (X, Y, and Z)

[Bernard Liengme]

Excel cannot make 3d scatter charts, only 'Line" charts in which the values
on the 3 axes are categories not true numeric values
Add-ins (SigmaPlot, for example) can be used to get what you want
best wishes

 

[Herbert Seidenberg]

Excel 2007 3D PivotChart
In case you don't have $749 for SigmaPlot,
here is a 3D spiral with balls.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_18_09.xlsm

 

[Andy Pope]

Hi,

You can use formula to calculate 3d position for plotting in 2d.
http://www.andypope.info/charts/3drotate.htm

Cheers
Andy

SML wrote:

 

[kyr]

Dear Herbert,

The result you produced is very impressive. I tried to use it in my data, but it was impossible to find the way to depict "balls" instead of "bars". Could you please explain me the way you did it?
Moreover, is there any way in Pivot Tables to put labels in the balls, or at least change colour in them?

Thank you in advance for your response. I am really counting on it!