Chart & Visualization Issues

Fix an Excel Line Chart Series That Stops Displaying

Rana GarciaRana Garcia Nov 18, 2026 870 views

Question details

Determine why one series in an Excel line chart stops displaying even though daily values exist in the worksheet.

Fix an Excel Line Chart Series That Stops Displaying
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the chart data settings

Select the chart, then choose Chart Design > Select Data.

2
Inspect the affected series

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.

3
Compare series and date labels

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.

4
Correct the references

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 and align the chart series source range
Free Microsoft Office alternative

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.

Create and edit line charts in WPS SpreadsheetOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday tasksMove existing spreadsheets into a free, lightweight office suite
microsoft office alternative - wps office

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.