Share via

How to make 3 dimension ( X, Y, Z axis) Scatter chart in Excel?

Anonymous
2012-01-06T12:20:29+00:00

How can we make a scatter chart with 3 Axes ? Also we need facility to rotate it to get better view.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-01-06T12:56:45+00:00

    One technique you could try is to plot a 3-D column chart witha  z-axis.  When you have done this, select each series in turn, press Ctrl+1 to open the Format Series window, select Fill and set No Fill and then straight away select Picture for fill, click the Clip Art button and search for Bullet.  Choose a simple round bullet shape and then select to apply this to the End of the column.  Repeat this for each series of columns and the pictures on the tops of the columns should appear like scatter markers.

    70+ people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2012-01-06T12:45:16+00:00

    Excel does not make XYZ scatter chart, rahter it makes Line charts. So the 'numbers' are treated as test and the spacing is all wrong. Maybe in the next version ? Meanwhile you will need something like

    Origin  http://www.originlab.com/index.aspx?go=Products/Origin/Graphing

    SignaPlot http://www.sigmaplot.com/products/sigmaplot/sigmaplot-details.php

    Grapher http://www.scisoftware.com/products/grapher_new/grapher_new.html 

    best wishes

    5 people found this answer helpful.
    0 comments

10 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-08-14T09:02:08+00:00

    Try this, seems to work nicely. http://www.doka.ch/Excel3Dscatterplot.htm Otherwise you can try R (install R, then from within R install package R commander and also some R commander plugins. Rkward also works nicely for beginners of R, its just like a normal spreadsheet programme with menus, but built upon R).

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-02-26T14:57:17+00:00

    Try setting the fill to 'No fill' on all sides just before you select the clip art to make the bullet on the end.  Is your spreadsheet saved in the new .xlsx format as well?   I've put an example at http://www.allaboutoffice.co.uk/slidereg2.xlsm

    0 comments
  3. Anonymous
    2013-02-21T15:25:06+00:00

    Well, I did that. The problem is that when I put the 'bullet' at the end of the column the sides/faces are grey instead of transparent. Now what?

    0 comments