Create a 100% Stacked Bar Chart in Excel Office 365!!

In the 100% Stacked Bar Chart, the data series of various categories are stacked one upon another in horizontal columns. It has 2-D and 3-D variations. This chart will show the relative percentage of multiple data series in stacked bars, where the total of each stacked bar always equals 100%. In this article, we will show you the steps to create a 100% Stacked Bar Chart in Excel Office 365.

Insert a 100% Stacked Bar Chart in Excel:

• You need to select the cell range that you want to create a chart.

• Go to the Insert Tab on the ribbon and click the 100% Stacked Bar Chart ** option under the **Charts section. you can select 2-D or 3-D bars as you wish.

• Now, you will see the chart in the current worksheet as shown in the below screenshot.

Pros and Cons:

Pros:

• It is able to show part-to-whole changes over time.
• Display the multiple data series and categories in a compact space.

Cons:

• It is difficult to compare all the data series except the first.
• Visually complex.
• The stacked bars are normalized to 100%, so the absolute value dimension will be lost.

Verdict:

In this article, you can quickly understand the steps to create a 100% Stacked Bar Chart in Excel Office 365. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!