Create a 100% Stacked Bar Chart for Multiple Categories in Excel
Question details
Create a chart that compares paired values for multiple subjects across time periods, with each pair totaling 100%.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The source data contains pairs such as Marriage and No Marriage, Disease and No Disease, and Death and No Death for each time period.
- Observed behavior
- The desired chart should show a separate 100% bar for each subject and time period.
Identify the two values for each subject and time period, and check that they represent parts of the same total. Each pair must have a nonzero total to display meaningful percentages.
Restructure the data and insert a 100% stacked bar chart in Excel
Use a helper table to make each subject and time period a separate bar with two segments.
Putting all six values for a period into one stack would calculate percentages across all six values, rather than within each pair. A separate row for each period and subject keeps the pairs independent.
In a blank area of the worksheet, enter the headers Period, Subject, Yes, and No. Add one row for each period and subject, such as 2024, Marriage, 60, 40, and another for 2024, Disease, 20, 80.
Fill the Yes and No columns with the corresponding values for each subject, including Death and No Death. Repeat the period label on every relevant row and use the same subject labels for each period.
Select the entire helper table, including headers, then choose Insert > Insert Column or Bar Chart > 100% Stacked Bar. Choose 100% Stacked Column instead if you prefer vertical bars.
Confirm that each period and subject has its own bar with two segments. If Excel plots the table in the wrong direction, select the chart and choose Chart Design > Switch Row/Column.

Build a 100% stacked bar chart in WPS Spreadsheets
Arrange each period and subject on its own row, then use WPS Spreadsheets to chart the paired values as two segments of a 100% bar.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Arrange the data: Create columns for Period, Subject, Yes, and No. Enter one row for each subject and period, with the paired values in the last two columns.
- 3. Insert the chart: Select the helper table and choose Insert > Chart. Select Bar and choose the 100% stacked bar subtype.
- 4. Review the result: Check that each subject and period appears as a separate bar with two segments. Adjust the chart's data orientation from the chart options if needed.

Frequently Asked Questions
Why does my chart combine all six values into one 100% bar?
Excel normalizes all series in a single stack together. In the worksheet, put each subject and period on a separate row with only its two paired values in the value columns.
Can I use a 100% stacked column chart instead?
Yes. Select the helper table and choose Insert > Insert Column or Bar Chart > 100% Stacked Column. It uses the same data arrangement but displays vertical columns.
Do the source values need to add up to 100?
No. The two values can be counts or other comparable quantities. Excel calculates their share of the pair's total, provided that total is not zero.
How do I fix bars and series that are reversed?
Select the chart in Excel and choose Chart Design > Switch Row/Column. Then check that each bar represents one subject and period and that the two segments represent its paired values.




