How to Make a 100 Percent Stacked Bar Chart in Excel (with Easy Steps)

This article illustrates how to make a 100 % stacked bar chart in excel. You can present the data in a data series as percentages using the 100% stacked bar chart. For example, assume a data series contains the numbers 20, 40, 60, and 80. They make a total of 200. Now, the contribution of the numbers to the total is 10%, 20%, 30%, and 40% respectively. A 100 % stacked bar chart will show these percentages and not the actual values. Therefore, it always adds up to 100% and hence the name.


Download Practice Workbook

You can download the following practice workbook from the download button below.


What Is a Stacked Bar Chart?

So, what is a stacked bar chart? A stacked bar chart is a graph to represent and compare the segments of a whole. It can show the parts of a whole data series. A stacked bar chart usually has several bars and each of them is divided into multiple segments. Each bar represents a different data series and each part or segment of a bar represents a particular category within that data series. A stacked bar chart is used to show a larger variable divided into smaller categories and then compare the categories across different variables. In the case of a 100 % stacked bar chart, each bar makes up a total of 100%.

100% stacked bar chart in excel


Steps to Make a 100 Percent Stacked Bar Chart in Excel

Apply the following steps to make a 100% stacked bar chart in excel.

πŸ“Œ Step 1: Organize Data Properly

  • Assume that you have the following dataset. The dataset contains the monthly sales of 3 different stores. You can make a 100% stacked bar chart to show and compare the contributions of the stores to the total sales.

Read More: How to Sort Bar Chart Without Sorting Data in Excel (with Easy Steps)


πŸ“Œ Step 2: Insert 100% Stacked Bar Chart

  • Now select Insert >> Insert Column or Bar Chart >> 2-D Bar >> 100% Stacked Bar. Alternatively, you can select the 3-D 100% Stacked Bar from 3-D Bar.

Insert 100% stacked bar chart in excel

  • After that, the following 100% stacked bar chart will be inserted.

Read More: How to Make a Stacked Bar Chart in Excel (2 Quick Methods)


πŸ“Œ Step 3: Edit Chart Title

  • Now click on the chart title and enter a title as required.


πŸ“Œ Step 4: Pick a Suitable Chart Style

  • Next, you can choose a style for the bar chart from the Chart Design tab. You just need to click on the chart to be able to access it.


Similar Readings


πŸ“Œ Step 5: Format Chart Axes

  • After that, click on the chart axes to apply text formatting to make the chart more presentable.

Read More: Excel Bar Chart Side by Side with Secondary Axis


πŸ“Œ Step 6: Change Bar Colors

  • Then, click on any particular data series on the bar chart. Next, right-click and choose the desired fill color.

Read More: How to Change Bar Chart Color Based on Category in Excel (3 Methods)


πŸ“Œ Step 7: Add Data Labels

  • Note that the 100% stacked bar chart doesn’t show the actual value. Rather it represents their percentages. Now, to show the actual value on the bar chart, check the Data Labels checkbox from the Chart Elements.

Read More: How to Change Bar Chart Width Based on Data in Excel (with Easy Steps)


πŸ“Œ Step 8: Finalize 100% Stacked Bar Chart

  • After that, you can customize the bar chart further if needed by following the steps above. Finally, you will get the following result.

100% stacked bar chart in excel

Read More: How to Create Stacked Bar Chart with Line in Excel (2 Suitable Examples)


Things to Remember

  • You must select the chart to be able to customize it.
  • It is easy to compare the first series using this chart but difficult for other data series.

Conclusion

Now you know how to make a 100 % stacked bar chart in excel. Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo