How to Create Clustered Stacked Bar Chart in Excel

Get FREE Advanced Excel Exercises with Solutions!

There are different kinds of charts in Excel. In business, we often need the clustered stacked bar chart. If you don’t know how to create it, you have come to the right place. I hope this article will provide you with some easy steps to create a clustered stacked bar chart in Excel with clear images.


Watch Video – Create Clustered Stacked Bar Chart in Excel


What Is a Clustered Stacked Bar Chart?

A cluster-stacked bar chart contains clusters of columns or bars that are stacked in each column or bar. It is one of the most commonly used charts in Excel.


How to Create Clustered Stacked Bar Chart in Excel: With Easy Steps

It is first, introduced to our dataset that represents quarterly sales for 2 years of a company in three regions.

Steps:

  • First, select the data range C4:G12.
  • Then click as follows: Insert > Insert Column or Bar Chart > Stacked Column.

How to Create Clustered Stacked Bar Chart in Excel

Soon after, a stacked column chart will appear on your sheet.

How to Create Clustered Stacked Bar Chart in Excel


How to Customize Clustered Stacked Bar Chart in Excel

In charts, there are a lot of customizations by which you can make the outlook of your chart far better and make them easy to understand. In this section, we’ll learn the most essential and required customizations with clear illustrations.


Changing Column Gap Width

First, we’ll change the column gap width. That means you can change the distance between the columns

Steps:

  • Right-click on any cluster.
  • Then select Format Data Series from the context menu.

How to Create Clustered Stacked Bar Chart in Excel

Soon after you will see that a formatting field has appeared on the right side of your Excel window.

  • Set the gap width to 0%.

How to Create Clustered Stacked Bar Chart in Excel

Now have a look, the gap has gone between the columns, and we have continuous clustered columns.

Read More: Excel Chart Bar Width Too Thin


Formatting Vertical Axis

By formatting the vertical axis, we can change the limit of the axis value, major and minor units, etc.

Steps:

  • Right-click on the vertical axis.
  • Then select Format Axis from the context menu.

How to Create Clustered Stacked Bar Chart in Excel

  • Now set the minimum and maximum limits, and I set the maximum limit of 80000.

How to Create Clustered Stacked Bar Chart in Excel

Then you will get the chart like the image below.

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


Changing Chart Design

Excel has different kinds of chart designs, and from there you can choose the required design according to your choice.

Steps:

  • Click anywhere on the chart.
  • Next, click on the Chart Design ribbon and select the required design from the Chart Styles section. I selected the second one- Style 2.

How to Create Clustered Stacked Bar Chart in Excel

See, this design shows the values in the cluster.

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


Changing Color

In any chart design, you can change the color of the columns. By changing the color you can make your chart more beautiful.

Steps:

  • Click anywhere on the chart.
  • After that, click as follows: Chart Design > Change Colors and then select your desired color. Here, I selected the third one- Colorful Palette 3.

How to Create Clustered Stacked Bar Chart in Excel

Now you see, the color of the chart has changed according to my selection.

Read More: How to Change Bar Chart Color Based on Category in Excel


Editing Cluster Border

If we set a border for every cluster then will look better and we’ll be able to discriminate between them easily.

Steps:

  • Follow the first two steps from the Change Column Gap Width section.
  • Then click on Fill & Line icon.
  • Later, mark Solid line and choose a color from the Border section. I chose the black color.

How to Create Clustered Stacked Bar Chart in Excel

Now see, the selected clusters have black borders.

  • Follow the same process to add borders for the other clusters.

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


Download Practice Workbook

You can download the free Excel workbook from here and practice independently.


Conclusion

That’s all for the article. I hope the procedures described above will be good enough to create a clustered stacked bar chart in Excel. Feel free to ask any questions in the comment section and give me feedback.


Related Articles


<< Go Back to Stacked Bar Chart in ExcelExcel Bar ChartExcel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo