Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

up vote 2 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
0
1
2  1
3
4
5  4
6        5
7
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
1  
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
1  
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 http://5dchart.com 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.