How to make a 3D chart in excel

I found the same question but I'm not getting a 3D looking chart as posted in the answer.

My data looks like this:

 5 7 11 15 19
0.1 28 21 12 9 7
0.2 22 14 9 5 5
0.3 20 10 6 4 4
0.4 5 4 4 4 4
0.5 4 3 3 3 3
0.6 3 3 3 3 3
0.7 3 3 3 3 3
1.7 2 2 2 2 2
1.9 2 2 2 2 2

• Horizontal = X
• Vertical = Y
• Data inside: Z

Is there a way I can turn this into an XYZ-3D chart?

2 Answers

Excel 2013 does not have many charts that support a Z axis (and data visualisation experts are grateful for that. No more cylinder or pyramid cylinder eye candy junk).

The only two are a 3D Column chart and the surface chart. If you need a 3D scatter chart as linked to in your comment to Johnny Wright's answer, then it cannot be done in Excel, as Johnny Wright correctly states.

A chart like the below should be avoided, because it is impossible to tell the value of a column in the 3D layout.

If you look at the answer to the question you linked to, the accepted answer actually says "What you want may be outside the ability of Excel. Perhaps look into Mathmatica for more advanced 3-D graphing solutions."

I had a go and couldn't get it to work either so first it seems Excel is out of the question. Secondly, I can't see from your data how you would make a 3D chart anyway; whats the data for your X,Y,Z axes? In the question you linked to it is clear what data is for each of the axes;

 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

From your post I can't make out what data is what.