spot_img

How to make 3 axis graph

 

As you know how easy is to draw a 2D (with 2 axis) graphs in Excel. You can also draw 3D chart in Excel, which 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 of quarterly sales in million for the last 10 years, something like following.

Table Data

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

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

Ribbon Menu

And that’s it! You’ve just inserted 3 axis chart.

3 axis chart

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

3D rotation

Note: For learning purpose 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 in perspective.

Further reading:
4 axis chart
Chart with multiple series
Chart with subcategories
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial