Why Excel Scatter Charts Split Lines Around Missing Data

Excel XY Scatter charts break a line at blank or null points. The line can stay continuous only if the missing value is replaced or plotted differently.

Is this an expected behavior from Excel for Scatter Line Chart?

Yes. In an Excel XY Scatter chart with lines, a blank or null Y value breaks the series into separate line segments.

Scatter charts use numeric X and Y pairs. When one pair is missing, Excel does not interpolate that point automatically.

To keep one continuous line, replace the missing value with a real number, a calculated estimate, or switch to a chart type that supports hidden-and-empty-cell options.

The reported case shows one Department series drawing as two separate lines because one row in the source data is missing. That is normal for an Excel scatter chart with lines. Unlike a standard line chart, the scatter chart treats each point as an exact coordinate pair, so a missing pair creates a visible disconnect.

Excel usually leaves a gap in the scatter series.

If the chart receives no valid point, the line is split.

The line stays continuous because the coordinate pair exists.

A single line is possible only when every plotted point is defined.

Sample data used

The source data below shows the period and price values used to explain the chart behavior. A break appears only when one plotted point is missing from the series.

Period and price values

Request for a sample workbook

Troubleshooting chart behavior is easier when the workbook can be inspected directly. That helps confirm whether the issue comes from blanks, formulas, or the series range itself.

A sample file reveals the exact chart type, source range, formulas, and any hidden formatting that screenshots cannot fully show.

What to inspect first

Check the row where the line breaks, then verify the series X values and Y values to confirm whether the missing point is truly absent.

File-sharing limitation noted

The source discussion notes that direct file attachments were not available in that support channel. A view-only share link was suggested instead so others could download and inspect the workbook.

Use a view-only link that does not require sign-in

When direct upload is unavailable, place the workbook on a file-sharing service and provide a downloadable view-only link. That preserves the original Excel file for diagnosis.

• Keep the file in Excel format.
• Use a link that opens without mandatory login.
• Avoid converting the workbook into another spreadsheet format during sharing.

Four common follow-up questions

Excel is behaving as designed when a scatter line breaks at a missing point

The split line in this Excel scatter chart is expected when one X/Y pair is incomplete. If you need a continuous line, the missing point must be supplied with a real or intentionally estimated numeric value and then verified in the chart.

Complete This Workflow with WPS Office

Use Word, Excel, and PPT for FREE

Free Download

WPS Office can inspect and update the local scatter-chart source directly in WPS Spreadsheets.

1. Open the XLSX copy in WPS Spreadsheets, select the scatter chart, and identify its X and Y source ranges.
2. Find the row where the line breaks and confirm whether the Y value is blank, text, an error, or excluded from the selected range.
3. Enter the verified missing value, or an approved estimate only when the reporting method permits interpolation. Do not invent a measurement solely to connect the line.
4. Refresh or reselect the chart data and confirm the line reconnects at the intended date without changing other points.

A missing numeric point normally creates a genuine gap; preserving the gap may be more accurate than filling it.

Excel Scatter Charts Split Lines Around Missing Data FAQs

Why does the line break even though the dates continue in order?

Because the date is only the X value. A scatter point still needs a valid Y value, and without that pair Excel has no point to connect through.

What is the safest way to keep one continuous line?

Use a real numeric value for the missing point, or a documented estimated value if your analysis allows it. Then refresh the chart and verify the gap disappears.

Is a split line expected behavior in an Excel Scatter Line Chart?

Yes. In an Excel XY Scatter chart with lines, a blank or null Y value breaks the series into separate segments instead of forcing one continuous line. Excel does not automatically bridge that gap.

Why does the scatter line chart split into separate segments?

The first valid points are connected as one segment. A blank or null row is treated as a break in the plotted series. The next valid points start a new segment, so one series can appear as two lines.