How to Create a 3D Bar Chart in Excel (3 Suitable Examples)

Undoubtedly, Excel’s powerful graphing feature can add visual depth and clarity to even the most mundane of datasets, while doing most of the heavy lifting for you. Keeping this in mind, this article will demonstrate 3 examples of creating a 3D Bar chart in Excel. In addition, we’ll also learn to make 3D Column charts in Excel.

3D Bar Chart in Excel: 3 Suitable Examples

First and foremost, let’s consider the Yearly Sales Data dataset shown in the B4:E9 cells containing the Location, and the Years 2020, 2021 and 2022 respectively. Here, we want to use the above information to generate a 3D Bar chart in Excel. Henceforth, let’s glance at each method in detail and with the appropriate illustrations.

Dataset for 3d bar chart excel

Here, we have used the Microsoft Excel 365 version; you may use any other version at your convenience.

1. Creating 3D Clustered Bar Chart

In the first place, let’s begin with a simple 3D Clustered Bar Chart to represent the location-based sales data spanning over three years.

📌 Steps:

  • First, go to the Insert tab >> click the Insert Column or Bar Chart drop-down >> select the 3D Clustered Bar chart option.

Creating 3D Clustered Bar Chart

  • Next, Left-click to select the chart >> choose the Select Data tab.

Clicking Select Data tab

  • Second, uncheck the Location category >> click on Series 1 >> press the Edit button.

Editing Series

  • Now, enter the Series name by choosing the C4 cell reference >> hit OK.

Entering cell reference for series name

  • In a similar manner, rename Series 2 and Series 3 >> press OK to close the Select Data Source dialog box.

Renaming all other series

  • Third, select the chart and Right-click to open the Contextual Menu >> choose a Fill color for the background, here we’ve chosen “White, Background 1, Darker 5%”.

Choosing Fill color

  • Afterward, click directly on the bars >> select a Fill color for the bars, here it is “Orange, Accent 2, Lighter 40%” >> repeat the same process for the other two series.

Selecting Fill color for the bars

  • Fourth, Left-click on the bars >> press CTRL + 1 >> choose a Border color for the bars, for example, “Orange, Accent 2” >> follow the same procedure for the two series.

Choosing border color for the bars

  • Finally, type in a suitable title, for instance, “Breakdown of Yearly Sales Based on Location” >> select the horizontal axis >> format the axis labels as Currency.

Formatting horizontal axis

Eventually, the final output should look like the image shown below.

3d bar chart excel creating clustered bar chart

Read More: How to Make a Simple Bar Graph in Excel

2. Inserting 3D Stacked Bar Chart

Alternatively, we can also insert a 3D Stacked Bar Chart to represent our sales data. Now, allow us to demonstrate the process in the steps below.

📌 Steps:

  • Initially, move to the Insert tab >> in the Insert Column or Bar Chart drop-down, and choose the 3D Stacked Bar chart.

Inserting 3D Stacked Bar Chart

Using Chart elements option

Subsequently, the results should resemble the picture given below.

3d bar chart excel inserting stacked bar chart

Read More: How to Create Clustered Stacked Bar Chart in Excel

3. Generating 3D 100% Stacked Bar Chart

Conversely, we can generate a 3D 100% Stacked Bar Chart that shows the values as a percentage. It’s simple and easy, so, just follow the steps.

📌 Steps:

  • To begin with, navigate to the Insert tab >> select the 3D 100% Stacked Bar chart option.

Generating 3D 100% Stacked Bar Chart

Consequently, the results should resemble the screenshot below.

3d bar chart excel making 100% Stacked bar chart

Read More: How to Make a 100 Percent Stacked Bar Chart in Excel

How to Make a 3D Column Chart in Excel

Last but not least, Excel allows us to make 3D Column Charts, so let’s see it in action.

📌 Steps:

  • At the very beginning, proceed to the Insert tab >> next, select the 3D Column option.

How to Make a 3D Column Chart in Excel

Inserting 3D Column chart

Read More: How to Flip Bar Chart in Excel

Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section for 3d bar chart excel

Download Practice Workbook


To sum up, we hope this tutorial has provided you with helpful knowledge on the 3D bar chart in Excel. Now, we recommend you apply all this know-how in the practice dataset by downloading the practice workbook. In addition, feel free to comment and provide your valuable feedback.

Related Articles

<< Go Back to Create a Bar Chart in Excel | Excel Bar Chart | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF