How to Create 3D Column Charts in Excel?

3D Column Chart

Avatar is a great movie – A James Cameroon masterpiece! But what made it even better was the IMAX 3D experience. How about bringing the same magic to data visualization in Excel too? Yep! That’s very much doable & we are about to explore one such feature in this article – 3D Column Charts.

We shall demonstrate the procedure to create 3D Column Charts (both clustered & separated) in MS Excel. Have a look at this article if you want to know about creating clustered column charts in 2D.

Following is the dataset containing the marks obtained by a group of students in History & Physics which shall be used for demonstration throughout this article.

Sample Dataset
Marks of Students in 2 Subjects

Steps for Creating 3D Column Charts in Excel

Let us get started by searching for the Insert tab among the list of available tabs. Hover the cursor over the Tabs section & click on the Insert tab as shown below.

Locating Insert Tab
Locating the Insert Tab

Once within the Insert tab, get into the Charts section & click on the Column Chart icon as shown below.

Selecting Column Chart Option
Selecting the Column Chart Option

Once done, there shall be a drop-down menu appearing as indicated in the below image with a list of variants in column charts to choose from. Select the 3D clustered column chart for comparing the marks of the students.

Selecting 3D Clustered Column Option
Selecting the 3D Clustered Column Chart Option

A blank chart area now appears! Right-click on that & choose the Select Data option as shown below.

Choosing Select Data
Choosing Select Data Option

Select Data Source pop-up shall now appear. Click on the Add option as indicated in the below image.

Selecting Add Series
Selecting Add Series Option

Now a dialog box titled Edit Series shall appear. Click on the arrow icon within the Series Values field to select all the values under column H for History marks. Now left click on H52 and drag till it reaches H56.

Selecting History Marks
Selecting History Marks

Hit ENTER and again follow the same sequence to select all the values under column I for Physics marks.

Adding Physics Marks
Selecting Add Option for Adding Physics Marks
Selecting Physics Marks
Selecting Physics Marks

Hit ENTER & we are again taken back to the Select Data Source pop-up. Click the Edit icon on the Horizontal Axis Labels section.

Selecting Horizontal Axis Labels
Selecting Horizontal Axis Labels

Now the Axis Labels pop-up appears. Follow the same steps as previously stated to select the data range & select the student’s list.

Selecting Students
Selecting Students List

Hit ENTER & we are again taken back to the Select Data Source pop-up. Hit ENTER again & we are taken back to the sheet which now has a 3D clustered chart created!

3D Clustered Column Chart Created
3D Clustered Column Chart Created!

The above chart easily compares the marks obtained by the students in both subjects side-by-side. The same approach is to be adopted if one has to create a 3D Stacked Column or 3D 100% Stacked Column chart.

However, if one wants to separate these columns into two different rows that can also be done! Click anywhere in the chart area & only then the Chart Tools section shall appear. Choose the Design tab within the Chart Tools & click on the Change Chart Type icon as shown below.

Changing Chart Type
Selecting the Change Chart Type Icon

The Change Chart Type dialog box appears & click on the option as shown below.

Changing to Separated 3D Column Chart
Changing to Separated 3D Column Chart

Now the chart recommendations appear & one can choose between the 2 choices on whether one wants to separate the columns by the subjects or whether one wants to separate the columns by the students along the Z axis.

Recommended Charts
Recommended Charts for 3D Separated Column Charts

After clicking OK, the corresponding chart shall appear.

3D Separated Clustered Chart
3D Separated Column Chart


To further edit how the chart appears, have a look at this article. There are numerous equally interesting & informative articles in QuickExcel that serve to be of great help to those who pursue their journey to excel in MS Excel. Hope this article helped you understand how to create a 3D Clustered Column Chart in MS Excel & has given you what you came looking for! Ciao.