How to Create a 3D Bar Chart in Excel

Consider the Yearly Sales Data dataset, containing “Location”, and “Years 2020”, “2021” and “2022” .

To generate a 3D Bar chart in Excel:

Dataset for 3d bar chart excel

Steps:

Go to the Insert tab >> click Insert Column or Bar Chart >> select 3D Clustered Bar.

Creating 3D Clustered Bar Chart

Rename Series 2 and Series 3 >> click OK to close the Select Data Source dialog box.

Select the chart and right-click to open the Context Menu >> choose a Fill color, here “White, Background 1, Darker 5%”.

Click the bars >> select a Fill color, here “Orange, Accent 2, Lighter 40%” >> repeat the same process for the other two series.

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

Enter a title, here, “Breakdown of Yearly Sales Based on Location” >> select the horizontal axis >> format the axis labels as Currency.

This is the final output.

Steps:

Go to the Insert tab >> in Insert Column or Bar Chart, choose 3D Stacked Bar.

Follow the previously described steps to format the chart >> click Chart Elements >> check the options shown below.

This is the output.

The 3D 100% Stacked Bar Chart shows values as a percentage.

Steps:

This is the output.

How to Make a 3D Column Chart in Excel

Steps:

Read More: How to Flip Bar Chart in Excel

Practice here.

Download Practice Workbook

Creating 3D Bar Chart.xlsx