A 3D clustered column chart is a type of chart that uses 3-D bars to visualize the values of multiple numeric variables clustered by a categorical variable.
This tutorial provides a step-by-step example of how to create the following 3D clustered column chart in Excel that shows the sales of two different products in various regions for some company:
Let’s jump in!
Step 1: Enter the Data
First, let’s enter the following dataset that shows the total sales of two different products in various regions for some company:
Step 2: Insert the 3D Clustered Column Chart
Next, highlight the cell range A1:C7, then click the Insert tab along the top ribbon, then click the 3-D Clustered Column icon within the Charts group:
This will produce the following 3D clustered column chart:
Step 3: Customize the Chart
To adjust the spacing and size of the bars, double click on any of the bars in the graph.
In the Format Data Series panel that appears, you can adjust the gap depth and graph width of the bars:
Note the following:
- Gap Depth: The higher the value, the deeper back into the chart the bars will be.
- Gap Width: The higher the value, the wider the individual bars will be.
Feel free to adjust these values to make the bars appear however you would like.
We will leave the values on their default settings for this example.
Lastly, feel free to change the color of the bars, add a title to the chart, and add a label for the y-axis:
The final chart displays the sales of products A and B along the y-axis with the regions displayed along the x-axis.
The following tutorials explain how to create other common visualizations in Excel: