Excel Stacked Bar Chart Not Proportional? Fix the Scale

Charts & pivot tables · Updated November 19, 2026

If an Excel stacked bar chart does not look proportional, first check whether it is a regular Stacked Bar chart or a 100% Stacked Bar chart: the regular type shows both each segment’s value and the total, while the 100% type makes every bar the same overall length to compare shares. In Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Change Chart Type to check or switch the type.

What proportional means in a stacked bar chart

A stacked bar combines multiple series into one bar for each category. Each colored segment represents a series value, and the full bar represents the sum of those values. In a regular stacked chart, a category totaling 120 should have a bar twice as long as one totaling 60, assuming the value axis uses a consistent scale and begins at zero. The segments also retain their actual magnitudes.

A 100% Stacked Bar chart answers a different question. It converts each category’s values into shares of that category’s total, so every bar has the same length. It is useful for comparing composition, such as the percentage of sales from online, store, and partner channels, but it deliberately hides differences in total size. A short category and a large category can therefore look equally long.

People often say a chart is not proportional when they expected one of these meanings and got the other. Decide whether you want to compare totals, segment sizes, or the mix of segments before changing the chart. No single stacked-bar format communicates all three equally well.

Check the chart type first

Click the chart, open Chart Design > Change Chart Type, and inspect the selected option under Bar. Choose Stacked Bar when the overall bar length should vary with the category total. Choose 100% Stacked Bar when every bar should represent 100% and the purpose is to compare the proportions within categories. These are separate chart types, not just different number formats.

You can also create either chart from selected data using Insert > Insert Column or Bar Chart, then choose Stacked Bar or 100% Stacked Bar under 2-D Bar. The names refer to horizontal bars; Stacked Column and 100% Stacked Column display the same kind of comparison vertically. In Excel for Mac, the chart options are also available from the Insert tab and the chart-type controls; ribbon wording or placement can vary slightly by release.

For example, imagine three products with channel values of 40, 35, and 25; 60, 30, and 10; and 20, 20, and 10. A regular chart produces totals of 100, 100, and 50, so the third bar should be half as long as the first two. A 100% chart makes all three bars equal in length, while showing different segment shares.

Find out why the bars look wrong

If the chart type is correct but the relative lengths still seem wrong, work through the source and scale rather than adjusting colors or labels. Check these common causes:

  • The totals are actually similar. A visual impression can be misleading when the differences are small. Add the values in each category and compare the sums.
  • The value axis has a nonzero minimum. A truncated axis can make differences look larger or can clip parts of bars. Right-click the horizontal value axis, choose Format Axis, and inspect Bounds. For a conventional stacked bar that compares totals, a minimum of zero is generally the clearest baseline.
  • The chart is 100% Stacked Bar. Equal-length bars are expected, even when the raw totals differ.
  • The source data contains percentages rather than counts or amounts. If each row already sums to 100%, a regular stacked chart will also show equal-length bars. That is mathematically correct for those inputs.
  • Some values are missing, text, or errors. A number stored as text may not contribute as expected. Check the source cells and the chart’s selected data range.
  • The series or categories are arranged incorrectly. Excel may be treating rows as series when you intended columns, or vice versa. Try Chart Design > Switch Row/Column and see whether the legend and category labels become sensible.

Also consider whether a few very large values are compressing the smaller bars visually. A common linear value axis preserves proportional lengths; it cannot make both extreme and tiny values easy to compare. If the range is wide, a different chart or a separate view may be more honest than forcing the stacked bars to look balanced.

Verify the data range and series

Click the chart and choose Chart Design > Select Data to see the chart data range, category labels, and series names. Make sure each row corresponds to a category and each numeric column corresponds to one stack segment if that is how the table is organized. For example, a table with product names in column A and three sales channels in columns B through D is usually a straightforward source for a stacked bar chart.

Look for totals accidentally included as another series. If the table has columns for Online, Store, Partner, and Total, selecting all four columns stacks the components and the total together. That makes each bar too large because the total is being counted a second time. Exclude the Total column from the plotted series, or keep totals in the sheet for checking while selecting only the component columns.

Check whether filters or hidden rows affect what is plotted. Use Chart Design > Select Data and, if needed, Hidden and Empty Cells to review how hidden data is handled. Excel charts generally omit hidden rows and columns unless the chart is set to show data in hidden rows and columns. A chart that changes after filtering may therefore be responding to the visible data, not changing its scale arbitrarily.

Understand the value axis and display units

In a horizontal bar chart, the value axis runs from left to right along the bottom or top; the category axis lists names vertically. Right-click the value axis and choose Format Axis to inspect its minimum, maximum, major units, and number format. If Bounds are set manually, Excel will not necessarily expand them to suit a changed dataset. Reset an unintended fixed bound to Auto, or set a suitable bound deliberately.

Axis bounds do not change the underlying values; they change the visible scale. A maximum that is too low can cut off the ends of bars. A minimum above zero can exaggerate differences because the visible lengths no longer start from the same baseline. For a standard stacked bar intended to compare total magnitudes, begin at zero and leave enough room for the largest total.

Number formatting can cause a different kind of confusion. Formatting the axis as Percentage changes how tick labels are displayed; it does not convert the source numbers into percentages or normalize each bar. For instance, a value of 40 formatted as a percentage may display as 4000%, not 40%, because Excel interprets 40 as forty units rather than 0.40. Use the 100% chart type or calculate proportions in the source data when the intended values are shares.

Show percentages without misleading readers

A regular stacked chart can be the right choice when readers need to see totals, but it is not ideal for comparing the share represented by a segment across categories. A 35-unit segment in a category totaling 50 represents a larger share than a 40-unit segment in a category totaling 100, even though the latter segment is longer. If composition is the main message, use a 100% Stacked Bar chart.

If you need percentage labels, calculate shares in helper cells and use those values as labels where appropriate. With category names in A2:A4 and the component values in B2:D4, enter the following in E2, then fill across to G2 and down through row 4:

=B2/SUM($B2:$D2)

For the first category with values 40, 35, and 25, the formula returns 0.4, or 40% when formatted as Percentage. The corresponding shares are 35% and 25%. Select the helper cells and apply Home > Number > Percent Style, then use those cells as custom data label values if your Excel chart’s data-label options offer Value From Cells. This labels the segments with percentages while keeping the chart’s plotted values separate.

Be clear about what the labels mean. A 100% Stacked Bar chart displays relative segment widths, but labels may show raw values unless you supply percentage values or choose suitable label options. Conversely, adding percentage labels to a regular stacked chart does not make its bar lengths proportional to percentages. The geometry still follows the plotted values.

Choose the chart that fits the comparison

Use a regular Stacked Bar when the total matters and the component values are nonnegative and add meaningfully. Examples include units sold by channel per product, staffing by department, or a budget divided into categories. Readers can compare totals from full bar lengths, though comparing a middle segment across categories is harder because its starting point shifts.

Use a 100% Stacked Bar when the mix matters more than the total: for example, the percentage of survey responses in each answer category or the market-share composition of groups with different sizes. Keep an accompanying total column or label if total size is important too, because normalization removes it from the bar length.

For precise comparisons of one segment across many categories, a clustered bar chart often works better: the bars for that series share a common baseline. For comparing totals and composition together, consider a regular stacked chart with clearly stated totals, or use two coordinated charts. Avoid stacking unrelated measures with different units, such as dollars and hours; adding them creates a total with no useful meaning.

Common misconceptions and practical fixes

One misconception is that every stacked chart should have bars of equal length. That is true only for a 100% stacked chart, or for data whose totals happen to be equal. Another is that color or segment order controls proportionality. Order and color affect readability, but bar lengths come from the plotted numbers and the value-axis scale.

A second misconception is that Excel is supposed to make each segment’s length comparable across categories in an ordinary stacked chart. Only the first segment in each bar starts from the same baseline; later segments start where the preceding segments end. This is why stacked charts are useful for totals and broad composition, but less suitable for precise comparisons of internal segments.

For a reliable final check, compare one category’s total with another using the source cells, confirm the selected chart subtype, inspect the value-axis bounds, and verify that no totals column was included as a component. If you change the source data later, recheck manually fixed axis bounds and any helper percentages. The chart may be accurately reflecting new data even when the old scale makes the result hard to interpret.

Frequently Asked Questions

Why are all my stacked bars the same length in Excel?
If the chart type is 100% Stacked Bar, equal lengths are intentional: Excel normalizes each category to 100%. They can also be equal in a regular stacked chart if the source totals are equal. Check Chart Design > Change Chart Type and add the source values in each category to confirm.

How do I make a stacked bar chart show different totals?
Use Stacked Bar rather than 100% Stacked Bar, and plot the raw component values rather than row percentages. Check that the chart includes the component columns only, not an additional Total column, and that the value axis starts at zero if you are comparing magnitudes.

Does changing the axis to Percentage make the chart proportional?
No. Axis number formatting changes the labels, not the plotted data or each bar’s total. Use 100% Stacked Bar to normalize categories, or calculate each component as a share of its row total and chart those proportions.

Why does one part of a stacked bar seem out of proportion?
Check the source value and whether the segment is a middle or final segment. In a stacked chart, only the first segment shares a common starting baseline across bars; later segments begin at different positions. A clustered bar chart may be clearer if precise comparison of that component is the goal.

Can Excel show both percentages and totals?
Yes, but the chart may need extra labeling. Use a 100% Stacked Bar for segment shares and add totals as labels from helper cells or as a nearby table. Alternatively, use a regular stacked chart to show total size and provide percentage labels calculated from each category’s component values.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.