Excel 图表没有显示全部数据
打开“图表设计 > 选择数据”，查看每个系列的区域。如果区域停在第 9 行而列表已到第 20 行，新行不会出现在图上。把源转换为表，或扩大区域。还要取消隐藏行并清除筛选，Excel 常常不把隐藏行画进图表。
本文目录
快速解答
打开“图表设计 > 选择数据”，查看每个系列的区域。如果区域停在第 9 行而列表已到第 20 行，新行不会出现在图上。把源转换为表，或扩大区域。还要取消隐藏行并清除筛选，Excel 常常不把隐藏行画进图表。
检查要点
八行样本的月合计为 7800、5400、8850、2400，总计 24450，累计为 7800、13200、22050、24450。若缺了 4 月，图上最后一根柱是 3 月，画出的合计是 22050，多半是区域少了一行。在 Google Sheets 中检查图表编辑器“设置”里的数据范围。
边界与兼容性
若某个系列其实有数字却看起来是一条贴着轴的平线，可能与大得多的系列用了同一轴，例如份额 0.3865 对着合计 24450，这时应使用次坐标轴。日期显示成 45299 是格式问题。透视表图表若漏掉新行，通常是透视表的源区域从未包含那些行，需要更改数据源并刷新。
完整英文示例、公式与作者备注
Excel How-toTested 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.