Chart & Visualization Issues

Create a 100% Stacked Bar Chart for Multiple Categories in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 872 views

Question details

Create a chart that compares paired values for multiple subjects across time periods, with each pair totaling 100%.

Create a 100% Stacked Bar Chart for Multiple Categories in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Build a helper table

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.

2
Enter all paired values

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.

3
Insert the chart

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.

4
Check the chart layout

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.

Restructure the data and insert a 100% stacked bar chart in Excel
How percentages are calculated: Excel scales the two values in each bar to 100%. The Yes and No labels refer to the subject named beside each bar.
Create the chart in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 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. 3. Insert the chart: Select the helper table and choose Insert > Chart. Select Bar and choose the 100% stacked bar subtype.
  4. 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.
Compare paired values as percentages for each subject and periodOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceCreate charts with the free WPS Office suite
microsoft office alternative - wps office

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.