Chart & Visualization Issues

Fix Excel Charts That Plot Text Values as Zero

Maira MehtabMaira Mehtab Nov 12, 2026 869 views

Question details

The user needs to make an Excel chart correctly plot numeric values that are currently stored as text.

Fix Excel Charts That Plot Text Values as Zero
Product
Microsoft Excel
Device & OS
not provided
Scenario
Numeric data contains decimal points or decimal commas and is used to create a chart.
Observed behavior
The chart treats the text values as zero instead of plotting their numeric amounts.
Before you start

Select several affected cells and check whether the values are aligned or formatted as text rather than numbers. Confirm which decimal separator your regional settings use, such as a period or comma, before converting the data.

Solution 1Recommended

Convert text values to numbers with Text to Columns

Use this method when an entire chart data range contains numbers stored as text and may include inconsistent decimal separators.

Charts plot numeric text as zero because the chart cannot interpret those cells as numbers. Converting the source range to real numeric values lets Excel use the values on the chart axis.

1
Select the source range

In Excel, highlight the cells containing the values used by the chart, including any affected decimal values.

2
Open Text to Columns

Go to the Data tab and select Text to Columns to start the conversion wizard.

3
Choose the data format

Select Delimited, click Next twice, then choose General as the Column data format.

4
Set the decimal separator if needed

Click Advanced in the wizard and set the Decimal separator to the character used by your data, such as a period or comma. Click OK, then Finish.

5
Verify the chart

Click a converted cell and confirm it behaves as a number, then review or refresh the chart to verify that the values are no longer plotted as zero.

Check the converted cells: A converted value should usually align as a number and work in calculations such as SUM. If the chart does not update, select the chart, open Chart Design, and use Refresh Data or reselect the source range.

Convert chart source text into real numbers in WPS Spreadsheet

WPS Spreadsheet can convert imported numeric text into usable numbers, account for decimal separator differences, and update charts so they display the correct data. The familiar spreadsheet interface also makes it easy to open and save compatible Excel workbooks.

  1. 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheet, and open the Excel workbook containing the chart data.
  2. 2. Select the imported values: Highlight the source cells, then open the Data tab and choose Text to Columns to start converting text values.
  3. 3. Set the conversion options: Choose General for the data format and use the advanced separator settings to match the decimal mark in the imported values, then click Finish.
  4. 4. Check the chart source: Confirm the converted cells calculate as numbers, then select the chart and use Select Data to verify that its series references the corrected range.
Convert text-formatted chart values into real numbers with Text to Columns or VALUE formulas.Resolve period and comma decimal separator mismatches before building a chart.Create and edit charts in a lightweight spreadsheet interface.Open, edit, and save Microsoft Excel .xlsx and .xls workbooks with broad compatibility.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel plot numeric text as zero in a chart?

Excel charts require real numeric values. If a cell contains digits stored as text, especially with an unrecognized decimal separator, Excel may interpret the value as zero when plotting it.

How can I tell whether a chart value is stored as text?

Select the source cell and check whether it has a text format, a warning indicator, or a leading apostrophe. You can also test it with =ISNUMBER(A1); TRUE means the cell contains a number, while FALSE indicates text or another value type.

What should I do when periods and commas are used incorrectly for decimals?

Confirm the decimal separator used by your regional settings, then use Data > Text to Columns > Advanced to specify the correct separator. Alternatively, use Find and Replace to change the decimal mark before applying VALUE.

Can I convert the values without changing the original imported column?

Yes. Enter =VALUE(A1) in a separate column, fill the formula down, and use the formula results as the chart's data range. This keeps the original text values available for reference.

Why does the chart remain unchanged after converting the cells?

The chart may still reference the original text range. Select the chart, open Chart Design > Select Data, and replace the series values with the converted numeric range.