How to make 3 axis graph

As you know, it’s easy to draw 2D (with 2 axis) graphs in Excel. You can also draw a 3D chart in Excel, with 3 axes: X, Y and Z.

How to draw?

The procedure is very similar to how you draw a 2 dimension graph. Suppose you have data on quarterly sales in millions for the last 10 years, something like the following.

Table Data three axis

See the data carefully. You have 4 x 10 data fields. Just follow these steps:

Insert 3D chart

Select the data, including labels, in the Insert ribbon tab go to the column and select the 3-D chart.

Ribbon Menu chart axes

The chart should now have three axes: the primary axis, the secondary axis, and the third axis.

And that’s it! You’ve just inserted a 3 axis chart. Your 3-axis chart is now ready to use. You can also customize it further by formatting the chart elements, adding labels or data markers, and changing the chart type as needed.

3 axis chart

Right-click on bars and select 3-D Rotation to adjust the grade visibility.

3D rotation chart three axes

Note: For learning purposes, use the table shown above (numbers in an increasing pattern). Otherwise, the result will be fairly unreadable since 3D charts just don’t work on a 2D surface, unless you actually rotate them and get things into perspective.

See also  How to Create Product Quality Dashboard