Excel: How to Create a 100% Stacked Bar Chart

A 100% stacked bar chart is a type of stacked bar chart in which each set of stacked bars adds up to 100%.

This tutorial provides a step-by-step example of how to create the following 100% stacked bar chart in Excel:

Let’s jump in!

Step 1: Enter the Data

First, let’s enter the following dataset that shows the points scored during four quarters by several different basketball teams:

Step 2: Insert the 100% Stacked Bar Chart

Next, highlight the cell range A1:E9:

Then click the Insert tab along the top ribbon, then click the 100% Stacked Bar icon within the Charts group:

This will insert the following 100% stacked bar chart:

The y-axis displays each of the team names while the x-axis displays the percentage of points scored in each quarter relative to the total points scored for each team.

For example, the Thunder scored 19 points in the first quarter and a total of 107 points.

Thus, they scored 19 / 107 = 17.8% of their total points in the first quarter.

This is why the first blue bar for the Thunder extends to 17.8% on the x-axis of the chart.

Step 3: Customize the 100% Stacked Bar Chart

Lastly, feel free to click on the individual elements of the chart such as the title, the axis labels, and the individual bars to customize the font size, font color and bar colors:

The 100% stacked bar chart is now complete.

Additional Resources

The following tutorials explain how to create other common visualizations in Excel:

Excel: How to Create a Diverging Stacked Bar Chart
Excel: How to Create Stacked Bar Chart with Subcategories
Excel: How to Show Percentages in Stacked Column Chart

Leave a Reply

Your email address will not be published. Required fields are marked *