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.
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.
- First, go to the Insert tab >> click the Insert Column or Bar Chart drop-down >> select the 3D Clustered Bar chart option.
- Second, uncheck the “Location” category >> click on Series 1 >> press the Edit button.
- Now, enter the Series name by choosing the C4 cell reference >> hit OK.
- In a similar manner, rename Series 2 and Series 3 >> press OK to close the Select Data Source dialog box.
- 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%”.
- 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.
- 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.
- 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.
Eventually, the final output should look like the image shown below.
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.
- Initially, move to the Insert tab >> in the Insert Column or Bar Chart drop-down, and choose the 3D Stacked Bar chart.
- At this point, follow the steps shown previously to format the chart >> click the Chart Elements icon >> tick the options shown in the figure.
Subsequently, the results should resemble the picture given below.
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.
- To begin with, navigate to the Insert tab >> select the 3D 100% Stacked Bar chart option.
- From this point, follow the prior steps shown to apply formatting to the chart.
Consequently, the results should resemble the screenshot below.
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.
- At the very beginning, proceed to the Insert tab >> next, select the 3D Column option.
- Later, apply formatting by following the steps shown above >> Ultimately, the end result should look like the figure given below.
Read More: How to Flip Bar Chart in Excel
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.
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.
- How to Show Variance in Excel Bar Chart
- How to Create a Bar Chart with Standard Deviation in Excel
- How to Create Overlapping Bar Chart in Excel
- How to Make Floating Bar Chart in Excel
- How to Create a Radial Bar Chart in Excel
- How to Create Construction Bar Chart in Excel
- How to Create Butterfly Chart in Excel