Excel Line Chart Not Showing All Data? How to Fix It

If an Excel line chart is not showing all your data, first check the chart’s source range and filters, then inspect hidden rows, blank or text-valued cells, and axis limits. In Microsoft 365 for Windows, select the chart and use Chart Design > Select Data to confirm which cells and series Excel is plotting.

What “missing data” can mean

A line chart can appear to omit data for several different reasons. Excel may not include the cells in the chart’s source range; it may exclude filtered or hidden rows; or it may include the values but fail to draw them as expected because they are blank, stored as text, or outside the visible axis scale. A line chart can also show every point while making some category labels invisible to avoid crowding. Those are separate problems and need different fixes.

Start by comparing the chart with the worksheet rather than assuming the chart itself is broken. Identify one specific missing value and its row or column. Then check whether that cell belongs to a plotted series, whether it contains a usable number, and whether its category is visible on the horizontal axis. This simple check helps distinguish omitted data from labels Excel has merely shortened or skipped.

Check the chart’s source range and series

Select the chart, open Chart Design > Select Data, and review the Chart data range and Legend Entries (Series). The source range should cover the full set of values and their category labels. If new rows were added below the original data, for example, an existing chart may still point only to rows 2 through 20 even though the worksheet now has data through row 25.

In the Select Data Source window, inspect each series with Edit. Confirm that Series name refers to the intended heading, Series values includes all the numeric cells, and the Horizontal (Category) Axis Labels range includes the matching labels. A series that stops one row early can leave the final point out or misalign values with categories. If the chart has several lines, check each series separately; one may have a shorter range than the others.

To add a missing series, choose Add in the Legend Entries (Series) area and specify its name and values.
To change the category labels, choose Edit under Horizontal (Category) Axis Labels and select the correct label cells.
If Excel interpreted rows as series when columns should be series, or the reverse, use Switch Row/Column and check the preview and legend.

For example, if dates are in A2:A13 and monthly sales are in B2:B13, the chart needs the dates as category labels and the sales values as a series. If the selection accidentally includes only A2:A10 and B2:B10, November and December are not part of the chart at all. Correcting the selected ranges is more reliable than copying the missing points into the chart manually.

Look for chart filters, worksheet filters, and hidden rows

A chart can have its own filter independent of the worksheet’s normal AutoFilter. Select the chart and click the Chart Filters funnel button beside it, if it is displayed. Review both Categories and Series, select any items that should appear, and choose Apply. A series or category unchecked here can disappear from the chart even though the source cells remain on the sheet.

Worksheet filters can also hide rows from a chart. If the chart changes when you filter a table, that may be expected: Excel charts generally omit data in filtered-out rows. To include hidden and filtered data, select the chart and go to Chart Design > Select Data > Hidden and Empty Cells. In the dialog, select Show data in hidden rows and columns if that option is appropriate for the chart. This setting can also include manually hidden rows, so consider whether showing those values is desirable before turning it on.

To test whether visibility is the cause, clear the worksheet filter temporarily and unhide the rows around the missing point. If the line returns, the source range probably contains the data but Excel is not displaying hidden rows under the current settings. On Mac, select the chart and use the Chart Design tab’s Select Data command; the dialog and its available options may be arranged differently from Windows. Excel for the web has a more limited chart-editing interface, so use the desktop app if you cannot find a needed setting.

Understand blanks and gaps in a line

A truly empty cell is not the same as a cell containing 0. In a line chart, a blank commonly creates a gap, which can make it look as if a point or part of the line is missing. To choose how Excel handles empty cells, select the chart and open Chart Design > Select Data > Hidden and Empty Cells. Under Show empty cells as, choose Gaps, Zero, or Connect data points with line, depending on what the data means.

Use Gaps when no measurement was recorded and connecting across it would imply continuity that is not known. Use Zero only when the blank genuinely means zero; otherwise the chart may suggest a sharp drop that never happened. Connecting points can be suitable when the missing observation should not break the visual trend, but it does not fill in or calculate the missing value. The worksheet remains unchanged whichever display option you choose.

Also check cells that look empty but contain a formula returning an empty string, a space, or a nonprinting character. Such cells may not behave exactly like genuinely empty cells. Click a suspect cell and inspect the formula bar; clear accidental spaces or correct the formula if appropriate. Do not replace missing observations with zero simply to make a line continuous.

Check axis limits and category labels

Sometimes all the values are included, but a point is outside the visible vertical scale. Right-click the vertical axis and choose Format Axis. Under Axis Options, look at the Bounds for Minimum and Maximum. If either is set to a fixed value, a valid point below or above that bound can be clipped. Reset the bound to Auto, or set a suitable range that includes the values.

Horizontal-axis labels can be skipped when there are many categories or little room. That does not necessarily mean the corresponding data points are missing: Excel may display only some date or category labels to keep them legible while plotting the full series. To inspect this, widen the chart, reduce label font size, or use the horizontal axis formatting options to adjust the label interval. For date data, Excel may use a date axis with a chosen unit or spacing; a label every few days can still accompany points for every day.

A line chart treats the horizontal axis as categories, which is useful for ordered labels such as months or product stages. If the spacing between numeric or date values must represent actual intervals—for example, measurements taken after 1, 2, and 10 days—consider an XY (Scatter) chart instead. A line chart spaces categories evenly; a scatter chart uses numeric horizontal positions. Choosing the wrong type can make the data look misleading even when all points are present.

Make sure the source values are usable

Excel may not plot a value as expected if a number is stored as text. Imported data often includes numbers with leading apostrophes, inconsistent decimal separators, or extra spaces. Click a cell and check whether the value is left-aligned unexpectedly, has a warning indicator, or is preceded by an apostrophe. Formatting a text value as Number does not always convert it; use the cell’s warning menu, Text to Columns, or an appropriate conversion method to turn the underlying value into a number.

Check for errors such as #N/A as well. Error values can interrupt or alter a plotted series, and formulas may deliberately return #N/A to suppress a point. If the error is unintended, fix the source formula or imported data rather than hiding the symptom in the chart. When a cell contains a formula, verify that the formula returns the value you expect for that row.

Keep the data arranged consistently: one column for categories and one column per series is a straightforward layout. Include a clear header row, avoid merged cells within the data block, and keep each series aligned with the same category rows. If data is added regularly, format the source block as an Excel Table using Home > Format as Table or Insert > Table. Charts based on a table can expand as table rows are added, reducing the chance that later records fall outside a fixed range. Confirm the chart source after changing the layout.

A practical troubleshooting order

Use this sequence to locate the cause without changing several settings at once:

Pick a missing point and confirm its worksheet value and category label.
Open Chart Design > Select Data and verify the chart range, series values, and category labels include that row.
Check the Chart Filters funnel and clear any unintended category or series selections.
Temporarily clear worksheet filters or unhide the row, then review the hidden-data option in Hidden and Empty Cells.
Inspect blanks, formulas, text-formatted numbers, and errors in the relevant cells.
Check vertical-axis bounds and confirm that the chart type suits the data.

After each change, look at the specific point you chose. This makes it easier to see which setting solved the issue and avoids creating a second problem—for example, including confidential hidden records in a chart that will be shared. If only labels are missing, compare the plotted line and markers rather than expecting every category name to appear on a crowded axis.

Frequently Asked Questions

Why is my Excel line chart missing the last row?
Most often, the chart’s source range ends before the new row. Select the chart, open Chart Design > Select Data, and extend the series values and category-label ranges to include it. If the source is an Excel Table, confirm the new record was added inside the table.

Why does my chart skip some dates on the horizontal axis?
Excel may be hiding some axis labels to prevent overlap while still plotting their data points. Widen the chart or adjust the horizontal-axis label interval. If the actual line points are absent too, check the source range, filters, and whether the date rows are hidden.

How do I show data from hidden rows in an Excel chart?
Select the chart and choose Chart Design > Select Data > Hidden and Empty Cells, then enable Show data in hidden rows and columns. Check the result carefully: this can expose values from rows hidden for a reason.

Should blank cells be shown as zero or as a gap?
Choose based on what a blank means. Use zero only if it represents a real zero measurement. Use a gap when no value was recorded, or connect points only when drawing across the missing observation is an honest representation of the data.

Why does my chart show zero instead of the cell’s value?
Check whether the source cell is actually blank, returns an empty string, contains text rather than a number, or has a formula producing zero. Also review the empty-cell display setting. Correct the underlying value or formula before changing chart settings that could misrepresent the data.

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.