Excel Chart Not Showing All Data

Tested in: The monthly totals used as a completeness check were evaluated in Google Sheets on 12 November 2026. Excel 365 menu names are the current desktop labels; I did not click Select Data in Excel this session.

How to build the chart in the first place is in How to Make a Chart in Excel. This page is about a chart that should already include every row and does not.

The range is too short

On the eight-sale sample, the four monthly totals are 7800 (Jan), 5400 (Feb), 8850 (Mar), and 2400 (Apr). They add to the grand 24450, and the running totals are 7800, 13200, 22050, and 24450. A column chart of those months should have four columns whose heights add (in value, not in pixels) to 24,450. If April is missing, the last visible column is March and the plotted total is 22,050 — the range almost certainly stops before the April row.

In Excel, click the chart, then Select Data. Each series should start on the first data row and end on the last. Category labels should cover the same rows. In Google Sheets, open the chart editor’s Setup and check the data range.

Typing new sales below the last row of a fixed range will not add a column until you extend that range. Converting the source to a table (Ctrl+T, or Insert > Table) and pointing the chart at the table columns is the more lasting fix.

Hidden rows, filters, and blanks

Filtered lists and hidden rows are frequently left off the chart even when they are inside the range. Clear the filter, unhide the rows, and see whether the missing points return. If you want hidden rows plotted, look at Select Data > Hidden and Empty Cells (Excel) and choose to show them.

Empty cells can appear as gaps, as zeros, or as a line that connects across the hole, depending on that same Hidden and Empty Cells setting (and the equivalent in Sheets). A text n/a in a value column is not a number and will break or skip a point; it is not the same as a blank.

The series is there but you cannot see it

A share such as East’s 0.38650306748466257 of 24,450 is invisible on an axis that runs to 25,000. Move that series to a secondary axis. Dates that appear as 45299 are a format issue, in chart dates showing as numbers.

A pivot chart will also drop new source rows if the pivot’s source range never included them. Widen the source or point it at a table, then refresh, as in change a pivot table data source.

Once Select Data shows every row you expect, and a sheet total such as =7800+5400+8850+2400 still equals 24450, the chart and the list are talking about the same numbers.