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?

2

6 Answers

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.

3

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 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.

For people with the same problems, there is a useful tool named FunFun, which allows people to use web languages like Html, Css and JavaScript in Excel.

Javascript has a lot of powerful libraries for data visualization, like vis.js and D3, that you can use with this Excel add-in to create any chart you want.

I made this chart with vis.js on the FunFun website that I directly loaded in Excel by pasting the link of the funfun online editor below:

As you can see, you can create a 3D bar chart pretty easily with multiple options just by changing the code on the Funfun online editor, witch has an embedded spreadsheet, where you can see the output of your code instantly.

Here are some screenshots(Website to Excel Add-in):

Hope it helps !

2

I had same problem and found your question. Since I don't use Excel, I solved it using plot.ly online tool:

1. Open
2. Choose Graph type = 3D mesh
3. Put your data into A,B,C columns in grid (not sure if space separated data is ok but copypasting from Google sheets works well)
4. Bind axes X,Y,Z to columns A,B,C
5. Profit :-)

1

I had a similar problem and solved it with a free EXCEL add-in from XonGrid ().

I loaded my x,y,z data in 3 columns in Excel, then used the add-in function Interp2d(...) to fill out a 2d matrix with x values labeling rows and y values labeling columns and interpolated z values populating the matrix. It was a simple matter then to plot a surface from the matrix using the surface plot tab in Excel.

XonGrid is very flexible and easy to use. You can space your grid points however you like and a number of interpolation methods are available. There is a clear set of instructions at the SourceForge link above.