# XYZ 3D-chart in Excel

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?

-
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

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.

-
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

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.

-

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.

-