How do you create a 100% stacked bar chart in Excel?

By /

A 100% stacked bar chart in Excel is a graphical representation that displays the relationship between multiple variables in a single bar. This chart type is useful when comparing the relative proportions of different categories within a larger data set. To create a 100% stacked bar chart in Excel, follow these steps:
1. Organize your data in a table with column headings and row labels.
2. Select the entire dataset, including the column headings and row labels.
3. Click on the “Insert” tab in the top menu and select “Bar” from the “Charts” section.
4. Choose the “100% Stacked Bar” option.
5. Your chart will be created with the data displayed as a stacked bar.
6. You can customize your chart by adding titles, labels, and changing the colors and design.
7. To see the exact percentage values of each category, right-click on the chart and select “Add Data Labels.”
8. Your 100% stacked bar chart is now ready to be used for data analysis and presentation.

Excel: 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.

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:

x

Related terms:

  1. How do I create a 100% stacked bar chart in Excel?
  2. How do I create a diverging stacked bar chart in Excel?
  3. how to create a stacked bar chart with subcategories in excel
  4. How to create a Stacked Bar Chart in Pandas
  5. How do I create a Stacked Bar Chart in Google Sheets?
  6. How to Add Total Values to Stacked Bar Chart in Excel
  7. How to reorder bars in a stacked bar chart in ggplot2?
  8. How can a clustered stacked bar chart be created in Google Sheets?
  9. How to Create a Stacked Bar Plot in Seaborn? (Step-by-Step)
  10. How to Create a Bar of Pie Chart in Excel (With Example)