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.