Chart & Visualization Issues

Fix a Stacked Bar Chart Displaying Incorrect Percentages

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to fix a stacked bar chart that displays data proportions incorrectly when multiple percentage values exceed approximately 84%.

Product: Spreadsheets
Device & OS: not provided
Scenario: Creating a stacked bar chart with high percentage values (e.g., 85% and 93%) where the visual rendering of the bars breaks or displays inaccurately.
Observed behavior: The chart renders individual values correctly when plotted alone, but fails to display accurate bar lengths when two values above 84% are stacked together.

Before you start

Ensure your data cells are properly formatted as percentages and that the underlying values do not contain calculation errors before modifying the chart axes.

Solution 1Recommended

Adjust the Primary Vertical Axis Bounds

Fix the visual rendering issue by manually enforcing the maximum and minimum scale of the chart's primary axis.

This issue typically occurs due to an automatic scaling conflict when charting multiple high-percentage values. Manually setting the axis bounds to strict percentage limits (0 to 1) resolves the calculation error in the chart rendering.

Display the hidden axis

Click on the chart to reveal the chart tools. If your primary vertical axis is hidden, temporarily turn it back on via the 'Chart Elements' menu.

Open Format Axis options

Right-click on the primary vertical axis numbers and select 'Format Axis' from the context menu to open the properties pane.

Set minimum and maximum bounds

Under Axis Options, change the Minimum bound to 0 and the Maximum bound to 1 (representing 100%). Alternatively, you can try resetting both values to 'Automatic' to refresh the scale.

Hide the vertical axis

Once the chart scale corrects itself and the stacked bars display the proper proportions, you can hide the vertical axis again if it is not needed for your presentation.

Chart rendering refreshed: Setting the maximum bound to 1 forces the spreadsheet to read the data purely as standardized percentages, eliminating overflow display bugs.

Seamless Data Visualization

Create Accurate Stacked Bar Charts with WPS Spreadsheet

WPS Spreadsheet provides robust, easy-to-use charting tools that handle complex data and high percentage values accurately. You can effortlessly adjust axis bounds and format elements to create perfectly proportioned charts without display glitches.

1. Insert a Stacked Bar Chart: Highlight your percentage data, go to the 'Insert' tab, click 'Chart', and choose the 'Stacked Bar' option.
2. Access Axis Properties: Double-click the axis you want to adjust. A formatting panel will instantly slide out on the right side of the screen.
3. Define Axis Bounds: In the 'Axis Options' tab, type 0 for the minimum and 1 for the maximum to ensure your percentages display flawlessly.

Accurate rendering of stacked bar charts and percentage-based visualsFully compatible with Microsoft Excel (.xlsx) chart elements and formatsIntuitive right-side properties panel for quick axis formattingFree and lightweight alternative to Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why does my stacked bar chart look incorrect when data exceeds 100%?

Standard stacked bar charts add absolute values together. If the sum of your data exceeds 100%, the total bar length will stretch beyond the logical limit. You may need to use a '100% Stacked Bar Chart' instead, which normalizes the values so they always fill exactly 100% of the axis.

How do I easily show or hide chart axes?

Select your chart, click the '+' (Chart Elements) icon that appears next to it, and check or uncheck the 'Axes' box. You can click the arrow next to 'Axes' to toggle specific horizontal or vertical axes.

Does this axis adjustment work for stacked column charts as well?

Yes. The underlying scaling issue is identical for both horizontal (bar) and vertical (column) stacked charts. You can apply the exact same 0 to 1 bound adjustments to the primary vertical axis on a column chart.

Excel & Data Problems