Chart & Visualization Issues

Fix Excel Chart Showing Wrong Line or Bar for a Category

Maira MehtabMaira Mehtab Oct 29, 2026 872 views

Question details

The user's Excel chart is displaying incorrect visual proportions (the wrong line or bar size) for specific categories relative to their actual data values.

How to Fix an Excel Chart Showing the Wrong Line or Bar for a Category
Product
Excel
Device & OS
not provided
Scenario
Creating or formatting an Excel chart to visually compare data values across different categories.
Observed behavior
The chart normalizes all data categories to 100 percent because a '100% Stacked Column' chart type was selected, causing absolute values to appear incorrectly as relative proportions.
Before you start

Review your dataset to determine whether you need to compare the absolute numerical values of your data or their percentage contribution to a total.

Solution 1Recommended

Change the Chart Type to Clustered Column

Switch the chart type from a 100% Stacked Column to a Clustered Column so that actual absolute values are plotted side-by-side rather than normalized to 100%.

A 100% stacked column chart is only appropriate when comparing each series as a percentage of the category total. Because it normalizes data, small and large totals will both reach the top of the chart (100%). If you need to see the actual scale and difference between individual items, a Clustered Column chart is the correct visualization tool.

1
Select the chart

Click anywhere on the problematic chart in your Excel spreadsheet to select it and reveal the Chart Tools.

2
Open the Change Chart Type dialog

Navigate to the 'Chart Design' tab (or 'Design' tab in older versions) on the top ribbon, and click on 'Change Chart Type' located in the Type group.

3
Select Clustered Column

In the dialog box, select 'Column' from the left-hand menu. Choose the 'Clustered Column' option (usually the first icon) and click 'OK' to apply the changes.

Change the Chart Type to Clustered Column
Immediate Adjustment: Once applied, the Y-axis will automatically re-adjust from percentages to your actual data value ranges, and the bars will be displayed side-by-side.
Easy Chart Customization

Create and Format Charts Instantly with WPS Spreadsheet

WPS Spreadsheet provides an intuitive charting interface that makes it incredibly easy to select the correct chart type, ensuring your data is always presented accurately without confusing formatting issues.

  1. 1. Open your workbook: Launch WPS Spreadsheet and open the Excel file containing the incorrect chart.
  2. 2. Select the chart element: Click on the chart to bring up the Chart Tools menu on the right side or top ribbon.
  3. 3. Change chart type: Click the 'Change Chart Type' button, select 'Column', and pick the 'Clustered Column' layout to restore your absolute values.
Easily switch between stacked, clustered, and 100% normalized charts with a single click.Fully compatible with Microsoft Excel (.xlsx) file formats and chart elements.Rich selection of built-in modern chart templates for professional data visualization.Lightweight software that loads large datasets and complex charts instantly.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel bar chart Y-axis go up to 100% instead of my actual data values?

This happens when your chart type is accidentally set to '100% Stacked Column' or '100% Stacked Bar'. This specific chart type calculates the percentage of each value against the total of its category. Changing the chart type to a standard 'Clustered Column' will display your actual numerical data values on the Y-axis.

What is the difference between a stacked column and a clustered column chart?

A clustered column chart displays data series side-by-side, making it easy to compare absolute values across categories directly. A stacked column chart places data series on top of one another to emphasize the total value of a category while still showing the individual breakdown.

How do I fix a line chart that is showing percentages instead of data points?

Similar to column charts, check if you have selected a '100% Stacked Line' chart. Right-click your chart, select 'Change Chart Type', navigate to the 'Line' category, and choose a standard 'Line' or 'Line with Markers' chart to display your true absolute data values.