Fix an Excel Line Chart Series That Stops Displaying
Question details
Determine why one series in an Excel line chart stops displaying even though daily values exist in the worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is comparing daily data series in a line chart and needs the affected series to display across the intended dates.
- Observed behavior
- One line stops partway through the chart. Its source range may start on a different row from the other series.
Identify the affected line and the worksheet rows containing its dates and daily values. Note the intended first and last dates so you can compare them with the chart's source ranges.
Check and align the chart series source range
Use this method when the affected line references different rows or ends before the intended data.
A different starting row does not always cause a problem, but it can produce gaps or misalignment if the values and date labels no longer correspond.
Select the chart, then choose Chart Design > Select Data.
Under Legend Entries (Series), select the affected line and click Edit. Check the Series values reference against the worksheet rows containing the intended daily values.
In Select Data Source, compare the affected range with the other series and check the Horizontal (Category) Axis Labels range. For example, investigate why one series uses rows 5–96 while others use rows 21–96.
Use Edit to select the intended value range and, if needed, the corresponding date-label range. Click OK and check that the dates and values align.

Check for missing values, errors, and hidden rows
Use this method if the source range is correct but the line still has gaps or stops.
Work with line charts in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility makes it easier to move existing files into WPS Spreadsheet, although it does not repair Excel itself.

Frequently Asked Questions
Can different starting rows make an Excel chart line appear misaligned?
Yes, if the series values do not correspond to the intended date labels. Select the chart and open Chart Design > Select Data to compare each series range with the horizontal axis label range.
How do I make Excel connect a line across blank cells?
Select the chart, then choose Chart Design > Select Data > Hidden and Empty Cells. Select the option to connect data points with a line, if that representation is appropriate.
Why are values in hidden rows missing from my chart?
Excel may exclude hidden worksheet data from the chart. Open Chart Design > Select Data > Hidden and Empty Cells and select Show data in hidden rows and columns, or unhide the rows.
What if the source range is correct but the line still stops?
Check the affected cells for blanks, formula errors, and numbers stored as text. Also confirm that the series reference includes the rows after the point where the line stops.




