Excel Line Chart Not Plotting Correctly? Fix the Data

If an Excel line chart is missing points, plotting the wrong values, or showing an unexpected axis, first check its source range and whether the source cells contain real numeric values. Select the chart, open Chart Design > Select Data, verify the data range and series, then check the axis and empty-cell settings; these are the most common places to find the cause.

A line chart can look wrong even when the worksheet values seem reasonable. Excel must interpret the selected cells as series of values and categories, and its chart settings determine how it treats dates, blanks, hidden rows, and errors. Work through the checks below in order, changing one thing at a time so you can see which correction fixes the display.

Start by identifying what looks wrong

Before changing the chart type or formatting, compare the chart with the data it is meant to represent. Look for a specific symptom: a series is absent, the line stops early, the horizontal axis shows numbers rather than labels, points appear in the wrong order, or values are compressed near the bottom. Each points to a different likely cause.

Missing line or series: the selected range may exclude its values, or Excel may have interpreted the rows and columns in the wrong direction.
Missing individual points: inspect those cells for blanks, errors, text-formatted numbers, or filtered or hidden data.
Unexpected spacing or order: check the category labels and axis type. A line chart usually spaces categories evenly, while an XY scatter chart positions values according to numeric x-values.
Values look flat or extreme: inspect the vertical-axis bounds and number formats, and check whether one unusually large value is stretching the scale.

Keep the worksheet data visible while you inspect the chart. If the source is a large range, temporarily highlight the relevant cells or copy a small representative sample to a spare area. This makes it easier to tell whether the problem is in the data or in the chart’s interpretation of it.

Check the chart’s source range and series

In Excel for Microsoft 365 on Windows, click the chart and choose Chart Design > Select Data. The Select Data Source dialog shows the chart data range and the series included in the chart. Confirm that the range covers the intended category labels and all the value cells, without including unrelated totals, notes, or blank columns.

Under Legend Entries (Series), select a series and choose Edit to inspect its series name and values. Check that the name points to the intended heading cell and that the values cover the expected rows or columns. Under Horizontal (Category) Axis Labels, choose Edit to verify that the axis labels refer to the correct cells. A range shifted by one row can pair each value with the wrong label, even though the plotted line itself appears continuous.

For example, suppose A1 contains Month, B1 contains Sales, and rows 2 through 7 hold six months of data. The intended chart uses A2:A7 as category labels and B2:B7 as the Sales values. Including row 1 among the values can make the heading part of the series; omitting row 7 drops the final month. The exact range displayed in the dialog is more reliable than guessing from the chart’s appearance.

If the data is in columns but Excel has treated each row as a series, choose Chart Design > Switch Row/Column. Check the legend and axis labels afterward: the correct orientation is the one that gives each intended line its own series name and places the intended categories along the bottom. Switch Row/Column changes how Excel interprets the selected range; it does not repair incorrect source cells.

Make sure the values are really numbers

Cells that look numeric may be stored as text. This can happen after importing a CSV file, copying data from a website, or using a different decimal or thousands separator. Text values may be ignored, treated inconsistently, or fail to produce the line you expect. Select a suspicious cell and check whether Excel displays a warning indicator or whether the value aligns differently from other numbers. The formula bar and cell format can offer clues, but formatting a text value as Number alone does not convert it into a number.

To correct a small set of text numbers, select the affected cells and use the warning menu if Excel offers Convert to Number. For imported data, check the import settings and regional decimal separator, then re-import or convert the values consistently. Also inspect cells with leading or trailing spaces, currency symbols entered as literal text, and values containing an unexpected apostrophe. After converting, confirm the line chart updates and that the points match the worksheet.

Check the category cells too. Dates stored as text may appear in an unexpected sequence or be treated as ordinary labels rather than dates. If the chart should show a true timeline, convert the source entries to actual Excel dates, then review the horizontal axis settings. A displayed date format does not prove that the underlying cell contains a date value; Excel dates are stored as numbers with date formatting.

Choose the right horizontal axis

A standard line chart is designed to compare values across categories such as months, product names, or stages. Its category axis typically gives each category equal spacing. That means dates such as January 1, January 2, and January 20 can occupy equal category intervals even though the elapsed time differs. This is often appropriate for monthly reporting, where each month should receive equal visual space.

If the spacing between dates or other numeric x-values must represent actual elapsed distance, an XY scatter chart is usually a better fit. A scatter chart uses numeric x-values to position points along a value axis; a line chart uses categories. This distinction is a common reason a line chart seems to plot data at the wrong positions even when every value is present. Select the chart and use Chart Design > Change Chart Type to compare available line and scatter options. Choose a scatter subtype with lines if you need connected points and proportional x-spacing.

For a line chart, right-click the horizontal axis and choose Format Axis. In Axis Options, review Axis Type when that control is available: Automatic, Text axis, or Date axis can produce different spacing and label behavior. A Date axis can be useful for a genuine sequence of dates, but it cannot turn text that merely resembles dates into valid date values. Also check the axis label interval and whether categories are displayed in reverse order if labels seem skipped or backwards.

Inspect blanks, errors, and hidden data

Blank cells can create gaps in a line, which may be correct if no measurement was recorded. To choose how Excel displays them, select the chart and choose Chart Design > Select Data > Hidden and Empty Cells. The available empty-cell options include displaying empty cells as Gaps, Zero, or connecting data points with a line. Use Gaps when missing observations should remain visibly missing; connecting points can be appropriate when a continuous trend is intended, but it visually implies continuity across the missing interval.

Do not assume that a formula returning an empty string is identical to a genuinely empty cell. A formula result, an error such as #N/A, and a cell with a space are different contents and may affect a chart differently. Inspect a troublesome cell directly. If a series has error values, decide whether the error should be corrected, excluded, or deliberately used to keep a point out of the chart. Avoid replacing missing measurements with zero unless zero is the true value: that changes the meaning of the data.

The Hidden and Empty Cells dialog also includes an option to show data in hidden rows and columns. If rows are filtered or columns hidden, the chart may omit those values unless this option is enabled. Conversely, turning it on can bring data into the chart that the worksheet view currently conceals. Review filters as well as manual hiding when the chart appears to skip a range of otherwise valid records.

Confirm the series layout and labels

Excel charts need to know which cells are series names, which are category labels, and which are values. A clean layout has one header row, one category column, and one or more adjacent columns of numeric values. Blank header cells or extra explanatory rows can cause Excel to assign generic series names or include an unwanted category. If the chart has multiple lines, compare each legend entry against its source column rather than relying on color alone.

When adding a new series, use Chart Design > Select Data > Add, then set the series name and series values to the intended cells. Make sure the number of value cells aligns with the category labels. If a chart is based on a table, adding a new data row directly below the table usually expands the table, but check whether the chart has included the new row; charts created from manually selected ranges may not automatically include later data outside that range.

For repeated reporting, converting a well-structured source range to an Excel table can make data easier to extend and filter. Select a cell in the data and choose Insert > Table, confirming whether the table has headers. Review the chart after adding records, especially if the workbook uses filters or more complicated ranges. A table helps manage a growing dataset, but it does not correct inconsistent headings, text values, or a wrong chart type.

Review the vertical scale and chart formatting

A correct line can look misleading if the vertical axis has unexpected bounds. Right-click the vertical axis and choose Format Axis. Under Axis Options, inspect Minimum and Maximum bounds and the major unit. If a bound has been fixed manually, new data may fall outside the visible range or appear compressed. Automatic bounds are a sensible diagnostic setting; after the data is correct, set deliberate bounds only when they improve comparison without obscuring important changes.

Also check whether the axis crosses at an unexpected value, whether the series uses a secondary axis, and whether number formatting makes values hard to interpret. A secondary axis can be useful when series have very different units, but it can also make their slopes appear comparable when they are not. For straightforward troubleshooting, temporarily return series to the primary axis and remove extra formatting, then restore only the settings the chart needs.

Markers can help distinguish individual observations, especially when there are few categories. Select a line and use Format Data Series to review its line and marker options. If the line is present but individual points are hard to see, markers or a more contrasting line color may solve the apparent problem without changing the data. Formatting improves readability; it cannot restore values excluded from the source range or fix an incorrect axis model.

A reliable troubleshooting order

Use this sequence to avoid making several changes at once:

Compare the chart against the intended source cells and note exactly which points, labels, or series are wrong.
Open Chart Design > Select Data and verify the chart range, series values, series names, and category labels.
Check suspicious source cells for text numbers, text dates, blanks, errors, spaces, or filtered and hidden records.
Decide whether the x-axis represents evenly spaced categories or measured numeric positions; switch to an XY scatter chart if proportional numeric spacing is required.
Review Hidden and Empty Cells, axis bounds, date or text axis settings, and series orientation.
After each change, compare the plotted points with their source cells and keep only changes that correct the intended display.

If the chart still behaves unexpectedly, make a copy of the workbook and create a simple test chart from a small, clean two-column sample. If that chart works, the issue is likely in the original range, data types, or settings. If it does not, check whether the sample itself contains errors or whether the chosen chart type matches the data. This isolates the issue without risking the original chart formatting.

Frequently Asked Questions

Why is my Excel line chart showing only one point?
Check whether the series values range includes multiple numeric cells and whether the remaining cells are stored as numbers rather than text. Also verify that the chart range was not limited to one row and that blanks, errors, or hidden data are not excluding the other observations.

Why does Excel connect my points in the wrong order?
A line chart connects categories in the order supplied by the source range; it does not automatically sort category labels by their meaning. Sort the source data into the intended sequence, or use an XY scatter chart when numeric x-values should determine point order and spacing.

How do I make Excel show gaps instead of zero for blank cells?
Select the chart and go to Chart Design > Select Data > Hidden and Empty Cells. Choose Gaps for empty cells. Check whether the cells are truly empty or contain formulas, spaces, or errors, because those contents are not interchangeable.

Should I use a line chart or a scatter chart for dates?
Use a line chart when dates are categories that should have equal spacing, such as consecutive monthly reporting periods. Use an XY scatter chart when the distance between dates must reflect the actual elapsed time, particularly when intervals are irregular.

Why did my chart stop updating when I added data?
The new rows may be outside the chart’s source range. Open Chart Design > Select Data and inspect the displayed range. If the chart uses a manually selected range, extend it or base it on a table and confirm that new rows are included.

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.