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.
The following tutorials explain how to create other common visualizations in Excel: