Site icon Best Excel Tutorial

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.

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.

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.

Here are some common customization options:

Rotate and Adjust the Chart

3D charts in Excel allow you to rotate and adjust the perspective to view data from different angles. To do this:

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

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.

Exit mobile version