Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table of data as follows:

    X   Y   Z
N1  2   5   6
N2  2   7   8
N3  0   1   2
N4  0   4   5
N5  9   10  10
N6  4   9   9
N7  0   2   4
N8  0   7   8
N9  0   7   8

Now I would like to make a 3D-chart, whose 3 axes are X, Y and Z. For each axe, the labels are 0, 1, 2, 3, ..., 10. So at place (2,5,6), I want to have a point labelled N1; at place (2,7,8), I want to have a point labelled N2... Finally there are 9 points in the chart.

Do you think it is realizable in Excel?

share|improve this question
What happens when you select the data and then choose from the Insert Ribbon from the Chart section i.e. Line then 3D Line ? – Darius Mar 18 '13 at 23:38
That doesn't give a chart I want... – SoftTimur Mar 18 '13 at 23:44
up vote 4 down vote accepted

This is only a partial solution. What you want may be outside the ability of Excel. Perhaps look into Mathmatica for more advanced 3-D graphing solutions.

If you create a grid, X horizontally, Z vertically, you can type the Y values in the cells.

   0  1  2  3  4  5  6  7  8  9 10
2  1
5  4
6        5
8        7
9              9
10                           10

Select it all and create a 3-D Cylinder chart. Your result will be like this. It's missing labels, and (0,4,2). You can add the labels manually.

3D Cylinder Chart

share|improve this answer
Thanks for posting this, saves me from uploading a screenshot of my version. @SoftTimur, here you can see the drawbacks of a 3D chart in action. What is the value of the blue column at position 2,6? Even with the gridlines, it's impossible to tell because the 3D perspective removes the relationship between the gridlines and the top of the column. – teylyn Mar 19 '13 at 0:26
Thanks for your comment, one more question... how did you add the gridlines on the floor? – SoftTimur Mar 19 '13 at 2:43
Left-click to select the axis where the 0 - 10 labels are, right-click, and select Add Major Gridlines. – Hand-E-Food Mar 19 '13 at 2:47

You need to arrange the data in a 11 x 11 grid (from 0 to 10 across and down). At the intersection of the X and Y values enter the Z value. Then chart the data as a 3D column chart with the right-most template in the drop-down

enter image description here

The result will be fairly unreadable, though, since 3D charts just don't work on a 2D surface, unless you can actually rotate them and get things in perspective.

share|improve this answer

You can use an Add-In. For example 5dchart Add-In for Excel In this case you need to set 4th axis values equal to 1, and after chart generating decrease the bubble size by click S- button several times.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .