Excel のグラフにすべてのデータが出ない
「グラフのデザイン > データの選択」で各系列の範囲を確認します。範囲が9行で止まり、リストが20行まであれば、新しい行はグラフに出ません。元をテーブルにするか範囲を広げます。行の再表示とフィルタ解除も必要で、Excel は非表示行をグラフから省くことが多いです。
目次
要点
「グラフのデザイン > データの選択」で各系列の範囲を確認します。範囲が9行で止まり、リストが20行まであれば、新しい行はグラフに出ません。元をテーブルにするか範囲を広げます。行の再表示とフィルタ解除も必要で、Excel は非表示行をグラフから省くことが多いです。
確認のポイント
8行サンプルの月合計は 7800、5400、8850、2400、総計 24450、累計は 7800、13200、22050、24450 です。4月が無ければ最後の棒は3月で、描画合計は 22050 になり、範囲が1行短いことが多いです。Google Sheets ではグラフエディタの設定で範囲を確認します。
注意点と互換性
系列に数値があるのに軸に張り付いた線に見えるなら、はるかに大きい系列と同じ軸を使っている可能性があります。比率 0.3865 を合計 24450 と同じ軸に置く場合は第2軸を使います。日付が 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.