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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"SML" wrote in message
...

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

Hi,

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

Cheers
Andy

SML wrote:

--

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

Thanks for sharing this 2d to 3d mapping Andy - you just saved my Sunday!

Cheers,
Elizabeth G

On Sunday, December 20, 2009 at 10:59:56 PM UTC+11, Andy Pope wrote:
Hi,

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

Cheers
Andy

SML wrote:

--

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

ÐÑÔÎÉÃÁ, 18 ÄÅËÁÂÒÑ 2009šÇ., 4:29:01 UTC+3 ÐÏÌØÚÏ×ÁÔÅÌØ SML ÎÁÐÉÓÁÌ:




For Excel 2010 - 2013 please try 5dchart Add-In. http://5dchart.com

Sure, I can help you create a 3-D scatter plot with 3 axis in Microsoft Excel. Here are the steps:

1. First, you need to have your data ready in Excel. Make sure you have three columns of data, one for each axis (X, Y, and Z). For example, let's say you have the following data:
   
   X-axis: 1, 2, 3, 4, 5
   Y-axis: 2, 4, 6, 8, 10
   Z-axis: 3, 6, 9, 12, 15
   
2. Select the data range that you want to use for the 3-D scatter plot. In our example, select cells A1:C5.
   
3. Go to the "Insert" tab in the Excel ribbon and click on the "Scatter" chart type. Choose the 3-D scatter plot option.
   
4. Excel will create a basic 3-D scatter plot for you. You can customize the chart by adding titles, labels, and changing the chart style.
   
5. To add a third axis (Z-axis), you need to add a series to the chart. Right-click on the chart and select "Select Data".
   
6. Click on the "Add" button to add a new series. In the "Series values" field, select the data range for the Z-axis (in our example, cells C1:C5).
   
7. Click "OK" to close the "Select Data" dialog box. You should now see the Z-axis added to the chart.
   
8. You can further customize the chart by formatting the axis labels, changing the chart layout, and adding a chart title.
   

That's it! You now have a 3-D scatter plot with 3 axis in Microsoft Excel.