Chart & Visualization Issues

How to Fix Incorrect Labels and Missing Lines in an Excel Chart

Maira Mehtab Sep 21, 2026 869 views

Question details

The user is trying to generate a multiple-line chart, but the chart displays incorrect labels and fails to plot certain lines due to underlying data issues.

Product: Excel
Device & OS: not provided
Scenario: Creating or modifying a multiple-line chart based on imported or manually entered dataset.
Observed behavior: The chart renders with missing lines and wrong labels, often caused by numeric values being stored as text or conflicting regional decimal settings.

Before you start

Before troubleshooting, check your data range for small green triangles in the top-left corner of the cells, as these indicate potential formatting errors that prevent charts from plotting correctly.

Solution 1Recommended

Convert Text-Formatted Values to Numbers

Use this solution if your numeric data is left-aligned or displays green error indicators, which means Excel is reading your numbers as text.

Excel charts cannot plot text values on a numeric axis. When numbers are imported or copied from another source, they often retain text formatting, causing the chart lines to disappear or drop to zero.

Select the problematic data

Highlight all the cells containing the data that is failing to plot on your chart.

Locate the error warning

Click the small yellow warning icon with an exclamation mark that appears next to the selected cells.

Convert to Number

Select 'Convert to Number' from the dropdown menu. The green indicators will disappear, and your chart lines should immediately populate.

Alignment Check: By default, text is aligned to the left and numbers are aligned to the right in Excel. This is a quick visual cue to verify if your conversion was successful.

Solution 2

Fix Decimal Separators Based on Regional Settings

Use this method if your computer's regional settings use commas instead of periods for decimal points, causing data mismatch.

Solution 3

Verify Data Arrangement and Series Setup

Use this solution to ensure your chart is pulling data from the correct ranges and differentiating between labels and values.

Create Charts Easily

Fix Chart Formatting Issues Quickly with WPS Spreadsheet

WPS Spreadsheet provides intuitive error-checking tools to instantly convert text to numbers, automatically detect data ranges, and generate flawless multiple-line charts with perfectly aligned labels.

1. Open your workbook: Launch WPS Spreadsheet and open the file containing the problematic chart data.
2. Highlight and convert data: Select the data range, click the floating warning icon, and select 'Convert to Number'.
3. Insert a new chart: Go to the 'Insert' tab on the top ribbon and select 'Chart'.
4. Select the Multiple-Line Chart: Choose the 'Line' category, pick the desired multiple-line chart template, and click 'OK' to instantly visualize your corrected data.

One-click batch conversion from text to numbersSeamless Microsoft Excel (.xlsx) format compatibilitySmart chart recommendations based on your selected datasetFree to use with a lightweight, familiar interface

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel chart showing zero or dropping to the baseline for my data points?

This happens when the data points are stored as text rather than numbers. Excel treats text in a value axis as zero. You must convert these cells to numeric formatting for the lines to appear correctly.

Can headings be formatted as text in an Excel chart?

Yes, category labels and column headings usually should be text. As long as the actual plotted data series beneath the headings are numeric, the chart will generate correctly.

How do I change the default decimal separator in Excel?

You can change this in Excel Options. Go to File > Options > Advanced. Under 'Editing options', uncheck 'Use system separators', and type your preferred character in the 'Decimal separator' and 'Thousands separator' boxes.

Why are my X-axis labels showing as numbers (1, 2, 3) instead of my actual text labels?

This means the chart has not recognized your label column. Right-click the chart, choose 'Select Data', click 'Edit' under 'Horizontal (Category) Axis Labels', and highlight the cells containing your text labels.

Excel & Data Problems