November 25, 2020

How to create a 3D Clustered Bar Chart in Excel

Let’s say we have the below dataset in the table. It contains the number of sales of the keyboard in 4 consecutive years in 2 metro cities in India.

Now to create the 3-D Clustered Bar Chart  based on the above table please follow the below steps.

  1. Select the entire table(A1:C5)
  2. Click the insert tab in menu bar
  3. In the Chart group, click the ‘Insert Column or Bar Chart’ icon

4. Select the chart style as ‘3-D Clustered Bar’ Under 3-D Bar.

5. The chart will look like below. The X-axis which is the horizontal axis shows the sale count and the Y-axis which is the vertical axis shows the year. You can edit the Chart Title on top of the chart as we edited the chart title as “3-D Clustered Bar Chart”. In this example, the 3-D Clustered Bar Chart in Excel is useful to show the comparison of the sale count over the years in 2 cities.

6. The color codes for kolkata and Delhi sale count variations are mentioned just below the 3-D Clustered Bar Chart. If you change the order of the columns, the order of plotting colors in the 3-D Clustered Bar Chart will also change(see below).

Note :

Leave a Reply

Your email address will not be published. Required fields are marked *