Excel Line Chart Not Showing a Line? Fix It

If an Excel line chart is not showing a line, first check that the chart has a numeric data series, that the series is included and visible, and that its line formatting is not set to No line. In Excel for Microsoft 365 on Windows, right-click the chart and use Chart Design > Select Data to verify the plotted range, then right-click the series and choose Format Data Series to inspect its line settings.

Start with the quickest checks

A blank-looking chart does not always mean the chart is broken. It may be plotting values that are all blank, hidden, outside the visible axis range, or represented by markers too small to notice. Check the chart and its source together before rebuilding it.

Look for a line series: Click the chart, then click an apparent data point or use Chart Design > Select Data. Confirm that the expected series appears in the list.
Check the source values: Confirm that the selected value cells contain numbers rather than text, empty cells, or errors. A line needs at least two plotted points to show a connecting segment.
Inspect the line appearance: Right-click the series, choose Format Data Series, and open Fill & Line. Under Line, choose Solid line and a contrasting color if the line is hidden.
Check the vertical axis: If its minimum and maximum bounds exclude the data, the line can be outside the plot area. Right-click the vertical axis and select Format Axis.

If the chart is completely empty, start with the data range and series list. If markers appear but there is no connecting segment, focus on the chart type and line formatting. These clues narrow the diagnosis quickly.

Confirm the data range and series values

Excel builds a chart from a source range. If that range omits the value column, stops before newer rows, or includes the wrong cells, the chart may show axes and labels without the intended line. Select the chart and open Chart Design > Select Data. In the dialog, review the Legend Entries (Series) list and select a series to inspect its name and values. The values should point to the cells that contain the numbers you expect to plot.

For example, suppose column A contains months and column B contains sales. A series should use the sales values in column B, while the month names should be used for the horizontal axis labels. If the series accidentally points to the month cells, Excel may treat them as text rather than numeric values. In Select Data, use Edit to correct the series values or Horizontal (Category) Axis Labels to choose the month labels.

Text that looks like a number can also be a problem. Values imported from a website or CSV file may be stored as text, sometimes because of leading apostrophes, spaces, or inconsistent decimal separators. A quick clue is that numbers stored as text are often left-aligned by default, although cell formatting can change alignment. Try selecting a few source cells and checking the formula bar and number format. Convert the data to real numbers using Excel’s available conversion options, such as the warning icon’s Convert to Number command when it appears.

Make sure the chart type can draw a line

A chart may look like a line chart while its selected series is actually set to another type, particularly in a combo chart. Click the chart and choose Chart Design > Change Chart Type. Select Line for the series that should connect the points. For a combo chart, inspect each series individually: one series might be a column chart while another is a line.

Also check whether the chart uses a line subtype that displays markers or whether it has been changed to a scatter chart or another type. A scatter chart can display connected points, but its horizontal axis is numeric rather than a category axis, so the result may not match a conventional month-by-month line chart. The right choice depends on the data: use a standard line chart for categories such as months, and consider an XY scatter chart when the horizontal values are meaningful numbers with uneven intervals.

If you selected only one observation, Excel has no second point to connect. A series with a single point can still be visible if markers are turned on, but without a marker there is no visible line segment. Add another valid observation or enable markers in Format Data Series under Marker.

Check whether the series line is turned off

Excel lets you format a series so that its markers remain visible while its connecting line is absent. It is also possible for the line to be white on a white chart background, extremely thin, or transparent enough to seem missing. Right-click a point in the series and select Format Data Series. In the formatting pane, open Fill & Line, expand Line, and choose Solid line. Set a clearly visible color and increase the width if needed.

Make sure you selected the data series rather than the chart area, plot area, or an individual point. The pane title and its options help identify the selected object. If only one point changes when you format it, you may have selected a single data point; click the series again or use the chart’s selection controls to select the entire series.

Markers and lines are separate settings. Under Marker, you can choose a built-in marker type and size; under Line, you control the connection between points. This distinction explains why a chart may show dots but no line, or a line with no dots. For many data points, markers can overlap and obscure the line, so try reducing marker size as well as choosing a contrasting line color.

Understand blanks, formulas, and errors

Missing observations can interrupt a line. In Excel for Windows, open Chart Design > Select Data, then choose Hidden and Empty Cells. Under Show empty cells as, select Gaps, Zero, or Connect data points with line, depending on what the blank means. A gap is appropriate when no measurement exists; zero is appropriate only when the value genuinely is zero; connecting points can be useful when a missing observation should not break the trend.

These choices affect how empty cells are drawn; they do not turn text into numbers or fix an incorrect range. Also, a formula that displays an empty-looking string is not necessarily the same as a genuinely empty cell. For example, a formula returning an empty string may be treated differently from a blank cell by the chart. If a formula-driven series behaves unexpectedly, inspect the formula results and test the chart’s empty-cell options. For a point that should explicitly not be plotted, Excel charts generally omit the error value #N/A, but do not replace valid data with errors unless that is an intentional part of the worksheet design.

Other errors, such as #VALUE! or #DIV/0!, can disrupt a series or leave unexpected gaps. Resolve the underlying calculation where possible, and check whether the chart has enough valid numeric points remaining to draw a segment.

Check axis limits and scale

A line can exist but sit outside the visible plotting area if the vertical axis bounds are fixed too narrowly. Right-click the vertical axis, select Format Axis, and look under Axis Options for Bounds. Set the minimum and maximum back to Auto as a diagnostic, or choose bounds that include all the data. For example, if every value is between 80 and 120 but the axis maximum is fixed at 50, the series will not be visible within the plot area.

Scale can also make a line seem flat rather than absent. If one unusually large value stretches the axis, the remaining points may cluster close to the bottom. Check the source values for outliers and confirm whether a logarithmic scale or a secondary axis is in use. In a combo chart, a series assigned to a secondary axis may appear at a very different height; use Format Data Series to check its axis assignment and compare both axis scales.

Check hidden rows, filters, and chart visibility

A chart may omit data in hidden rows or columns depending on its settings. In Chart Design > Select Data > Hidden and Empty Cells, check Show data in hidden rows and columns if hidden source values should still appear. If a table filter is active, some rows may be filtered out of the visible chart. Clear the worksheet filter temporarily to see whether the missing observations return.

Make sure the series itself has not been removed from the chart. In Select Data, an absent series can be added with Add; a present series can be edited. If the chart is based on a table, adding rows immediately below the table often expands its source automatically, but data pasted outside the table may not be included. Check the chart’s source range after adding new records rather than assuming it expanded.

On Excel for Mac, the chart tools and formatting pane have similar functions, but ribbon layout and dialog placement can differ. Select the chart and look for the Chart Design tab and its data-selection commands; if a named command is arranged differently, use the chart’s context menu or formatting pane. Excel for the web also supports chart editing, though some advanced formatting options may be more limited than in the desktop app.

A reliable troubleshooting sequence

Work through these checks in order so that each step tests a different likely cause:

Click the chart and verify its source range in Chart Design > Select Data.
Confirm that the intended series is listed and that its values are numeric cells.
Use Chart Design > Change Chart Type to confirm the series is a line or an appropriate combo-chart line.
Set the series line to Solid line with a visible color, and turn on markers temporarily if there may be only one point.
Set vertical-axis bounds to Auto and check for a secondary axis or extreme value.
Review blanks, formula results, filtered rows, and the Show data in hidden rows and columns setting.

As a diagnostic, create a small temporary chart from two known numeric values in adjacent cells. If the test chart draws a line, the original problem is likely its range, series settings, or formatting rather than a general Excel display issue. Remove the temporary chart after the test. Avoid deleting and recreating a complex chart until you have checked its series and formatting; rebuilding can discard useful axis, label, and layout settings.

Frequently Asked Questions

Why does my Excel chart show dots but no line?
The series may have markers enabled and its line set to No line, or the line may be too faint to see. Open Format Data Series > Fill & Line > Line and choose Solid line.

Why is my Excel line chart blank even though the cells have data?
The chart may reference the wrong range, the values may be stored as text, the series may be missing, or axis bounds may exclude the data. Inspect the series in Chart Design > Select Data and temporarily set axis bounds to Auto.

Why does my line chart stop at a blank cell?
Excel may be treating the blank as a gap. Use Chart Design > Select Data > Hidden and Empty Cells and choose whether blanks should appear as gaps, zeros, or connected points. Choose based on what the missing value means.

Why does Excel show only one point and no line?
A line segment requires at least two plotted points. Add another valid numeric observation, or turn on a marker so the single point is visible.

How do I make Excel include filtered or hidden data in a line chart?
In the chart’s Hidden and Empty Cells settings, select Show data in hidden rows and columns when appropriate. Also clear table filters temporarily to check whether filtered-out records are responsible.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.