Fix Excel Charts That Plot Text Values as Zero
Question details
The user needs to make an Excel chart correctly plot numeric values that are currently stored as text.

- 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.
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.
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.
In Excel, highlight the cells containing the values used by the chart, including any affected decimal values.
Go to the Data tab and select Text to Columns to start the conversion wizard.
Select Delimited, click Next twice, then choose General as the Column data format.
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.
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.
Convert individual text values with VALUE
Use a formula when only a few cells need conversion or when you want to preserve the original imported data.
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. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheet, and open the Excel workbook containing the chart data.
- 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. 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. 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.

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.




