XYZ 3D-chart in Excel

I have a table of data as follows:

    X   Y   ZN1  2   5   6N2  2   7   8N3  0   1   2N4  0   4   5N5  9   10  10N6  4   9   9N7  0   2   4N8  0   7   8N9  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?

Solution:

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 10012  1345  46        578        79              910                           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.