How to Create Clustered Stacked Bar Chart in Excel

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 clustered stacked bar chart in excel with clear images.


Download Practice Workbook

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


What Is Clustered Stacked Bar Chart?

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


Steps to Create Clustered Stacked Bar Chart in Excel

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


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.


Change 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 got continuous clustered columns.


Format 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, 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.


Change Chart Design

Excel has different kinds of chart designs, 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 is showing the values in the cluster.


Change 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.


Edit 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 got black borders.

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


Conclusion

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

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo