Google Sheets Chart Not Showing All Data? How to Fix It

If a Google Sheets chart is missing data, first check its source range in the Chart editor, then check whether the missing rows or columns are hidden or filtered and whether the chart type can display the data. In a browser, double-click the chart and open Setup to inspect the range, labels, and series; these checks usually reveal whether the problem is the chart settings or the data itself.

How Google Sheets decides what to chart

A chart displays the cells listed in its data range, interpreted according to the chart type and the roles assigned to rows and columns. For example, a table with dates in column A and values in column B might use A1:B20 as its range, column A as the horizontal axis, and column B as a series. If the range ends at row 10, values in rows 11 through 20 will not appear, even if they sit directly below the visible table.

Headers and labels matter, too. Google Sheets may treat the first row as a series name and the first column as category labels. If those options are set incorrectly, a header can appear as a data point, a category can be omitted, or the chart can interpret rows and columns in the wrong direction. The chart does not simply display every nonempty cell on the sheet; it uses the selected range and the chart’s interpretation of that range.

To inspect the setup, double-click the chart. In the Chart editor, choose Setup. Look at Data range, X-axis, and Series, then check whether Use row 1 as headers and Use column A as labels match the layout of your table. The chart editor updates as you change these settings, so you can check the effect without rebuilding the chart.

Check and expand the chart’s data range

A too-short or incomplete data range is one of the most common causes of missing chart points. In Chart editor > Setup, click the Data range field and compare its address with the full table. A range such as A1:B15 will exclude row 16 and anything below it. If the table has several columns, confirm the range includes each column you intend to chart, not just the first series.

You can edit the range directly or use the grid selector beside the field to select cells on the sheet. Include the header row when it contains useful series names, and include the category-label column when the chart needs dates, names, or other labels. For a table with a date column and two measurements in columns B and C, a range covering A1:C20 includes both series and their shared labels.

Check the first and last row numbers in the range, especially after adding new records.
Check that all intended series columns are included, including columns separated by other data.
Confirm that the range starts on the correct header and label cells.
If the chart uses separate ranges for its axis and series, inspect those fields as well as Data range.

Do not assume that adding new rows below the original table automatically extends every chart range. Reopen Setup after adding data and verify the last row included. If new records are added often, leave room in the source range or update the range as needed, while avoiding unrelated cells that could be interpreted as extra categories or series.

Look for hidden rows, filters, and filtered views

Data can be present in the selected range but not visible in the chart because rows or columns are hidden, or because a filter is excluding records. In Chart editor > Setup, look for Include hidden / filtered data. When available, turn it on if you want the chart to include values from hidden or filtered cells; leave it off if the chart should reflect only currently visible records. The option’s effect depends on the chart and the data state, so check the chart after changing it.

On the sheet, inspect row numbers for gaps, which can indicate hidden rows, and look for filter controls in the header row. A filter may hide records that do not meet its conditions without deleting them. If the chart is meant to show all records, clear the relevant filter or enable the hidden and filtered data option. If the chart is meant to show only the filtered subset, confirm that the filter criteria are correct rather than changing the chart to include everything.

Hidden columns can also matter when they contain a series or category labels. Unhide them temporarily to check the table structure. Be careful not to confuse a hidden row with a deleted row: the chart range may still include hidden cells, but whether they are plotted depends on the chart setting. Filter views are another reason two people may see different visible records; verify the active view and chart option before concluding that values have disappeared.

Fix headers, labels, and row-versus-column orientation

If the chart shows some values but assigns them to the wrong categories, review the header and label options before changing the underlying data. In Setup, Use row 1 as headers tells Sheets to treat the first row as series names. Use column A as labels tells it to use the first column for category labels. These are useful defaults for a conventional table, but a table arranged differently may need different selections.

Try Switch rows / columns if the chart has treated each row as a separate series when you expected columns to be series, or vice versa. For instance, a table with months across the first row and product names down the first column may need the opposite orientation from a table with months down column A. Check the legend and axis labels after switching; a chart that now includes all values but has an unintelligible legend is not yet configured correctly.

Blank header cells can make series difficult to identify, and repeated labels may be interpreted as separate categories rather than one grouped category. Give each data series a clear heading and keep category labels consistently placed. If your table contains a title above the headers, do not include that title row in the chart range unless you deliberately want it treated as part of the data.

Check for blanks, text values, and errors

A cell can look like a number or date while being stored as text. This often happens after pasting data from a website or importing a file. Text values may not plot as numeric measurements, and dates stored as text may not behave like dates on the axis. Check a few missing cells directly: confirm that they contain the expected value, and compare their number format and alignment with nearby entries. Changing the display format alone does not always convert text into a real number or date.

Blank cells and formulas that return an empty string can also create apparent gaps. A formula result that looks empty is not the same as a numeric zero, and chart behavior for empty values depends on the chart type and its settings. Decide whether a missing observation should remain blank, be represented by zero, or be shown as a gap; those choices communicate different things. Do not replace blanks with zero just to make a line look continuous unless zero is genuinely the right value.

Check the source cells for errors such as #N/A or #VALUE!, particularly if the chart is based on formulas. An error may prevent the expected point from appearing or make a series behave unexpectedly. Resolve the underlying error or use a deliberate approach to represent unavailable values. Also check whether numeric values are mixed with text such as a currency symbol typed into the cell; use a number format for display rather than adding nonnumeric characters to each value.

Make sure the chart type fits the data

Some chart types cannot show every kind of data in the same way. A pie chart represents one data series divided into slices; it is not a way to compare several independent series at once. A scatter chart expects numerical x-values and y-values, whereas a line chart commonly uses categories such as dates along the horizontal axis. If values seem to vanish after choosing a different chart type, return to Setup and check the series and axis assignments.

For a chart with several series, use a chart type that supports them and confirm each intended series appears in the Series list. If one series has a much larger scale than another, smaller values may technically be present but look like zero because they are compressed near the axis. In that case, check the vertical-axis bounds and consider whether a different chart type or separate chart would communicate the comparison more clearly. Avoid changing axis limits in a way that exaggerates differences.

For a line or column chart, check whether the horizontal axis has enough room to show all category labels. Labels can be crowded or omitted visually when there are many points, even though the underlying data is plotted. Widening the chart, reducing label density where the chart offers that control, or splitting a long time series into clearer views may help. Distinguish hidden labels from missing plotted values by hovering over points or checking the series and range in Setup.

Use a reliable troubleshooting sequence

Changing one setting at a time makes it easier to identify the cause than repeatedly rebuilding the chart. Start with the source table and proceed through the chart configuration in a consistent order:

Confirm the missing values are present in the cells and are not errors, text, or unintended blanks.
Double-click the chart and inspect Chart editor > Setup, including the full Data range.
Check X-axis, Series, header and label options, and Switch rows / columns.
Inspect the sheet for hidden rows or columns and active filters; check Include hidden / filtered data in Setup.
Confirm the chart type suits the number and kind of series, then review axis bounds and label visibility.
Make one change, inspect the chart, and undo or adjust it if the result does not match the intended meaning.

For a concrete example, suppose a chart shows the first 12 monthly sales figures but not the next three. First verify that the three later figures are numeric and that their rows are not hidden by a filter. Then inspect the chart range: if it ends at row 13 while the additional months are in rows 14 through 16, extend it to include those rows. If the range already includes them, check whether the date values are genuine dates and whether the chosen chart type uses the date column as its axis. This sequence separates a range problem from a filtering or data-format problem.

When to rebuild the source table or chart

If the source data is irregular, restructuring it can be more effective than adjusting chart settings repeatedly. A chart is easier to maintain when each column has one clear header, each row represents one observation, and values of the same kind occupy the same column. Avoid blank spacer rows inside a dataset and avoid placing notes or subtotals among the records you intend to plot. Put explanatory text outside the chart’s source range.

If the chart still behaves unexpectedly, make a temporary copy of the relevant data in a clean rectangular table and create a new chart from that table. This is a diagnostic step, not a requirement to discard the original chart. If the clean version works, compare its range and headers with the original; the cause may be an extra title row, a stray value, or a layout that is difficult for the chart editor to interpret. If it does not work, revisit the data types and chart type.

Google Sheets runs in a web browser, and the steps above refer to its Chart editor. Excel has its own chart interface and menus, so instructions for Excel should not be assumed to match Sheets. If you download a spreadsheet and open it in Excel, confirm the chart’s source data and settings there rather than expecting every option to carry over identically.

Frequently Asked Questions

Why does my Google Sheets chart stop at a certain row?
Most often, the chart’s data range ends at that row. Double-click the chart, open Setup, and check Data range and any separate X-axis or Series ranges. Extend the range to include the missing records.

Why does my chart ignore rows that are in the data range?
The rows may be hidden or excluded by a filter, or their cells may contain text, blanks, or errors instead of usable values. Check the sheet and the Include hidden / filtered data option in Chart editor > Setup.

How do I add new rows to a Google Sheets chart?
Open the chart’s Setup panel and extend Data range to cover the new rows. Then confirm that the added rows use the same columns and data types as the existing records and that the chart uses the intended labels and series.

Why are some chart labels missing even though the values appear?
With many categories, Sheets may not display every label because the axis is crowded. The points may still be plotted. Make the chart wider, reduce the number of categories shown, or use a clearer chart layout; also check that the labels are included in the X-axis range.

Why does a Google Sheets chart show zero or a gap instead of a value?
Check whether the source cell is truly zero, blank, a formula returning an empty string, text stored as a number, or an error. These cases can look similar in a chart but mean different things, so inspect the cell and choose a representation that reflects the data accurately.

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.