Google Sheets Blank Chart? Causes, Checks, and Fixes

A blank Google Sheets chart usually means the chart is pointed at the wrong cells, has no usable numeric data, or is configured for a chart type that does not fit the data. Select the chart, open its chart editor, and check Setup > Data range and Series first; then confirm that the source cells contain values Sheets can plot.

What a blank chart can mean

“Blank” can describe a few different problems. The chart object may appear as an empty frame with no axes or marks, or it may show a title and axes but no bars, points, or lines. A chart can also look blank because its marks are very small, its colors blend into the background, or its axis scale puts the data out of view. These cases have different causes, so note what is visible before changing settings.

Google Sheets builds a chart from a selected data range. It interprets some cells as labels or dates and others as series of values. If the range contains only headings, empty cells, text that cannot be plotted as numbers, or the wrong columns, the chart may have nothing useful to draw. The chart editor is the best place to check how Sheets has interpreted that range.

Check the chart’s data range and series

Click the chart and choose the three-dot menu > Edit chart, or double-click the chart. In the Chart editor, open Setup. Review Data range, X-axis, and Series. The range should cover the labels and values you intend to chart, and Series should include the column or columns containing the measurements.

For example, suppose A1:B4 contains a header row followed by three months in column A and sales figures in column B. The chart range should include A1:B4, not just A1:B1. If the range accidentally stops at the header row, there are no measurements to plot. If it includes unrelated blank columns or a distant empty area, remove those cells from the range or select the intended range again.

Use Add X-axis or Add series in Setup if Sheets has not assigned the intended cells.
Check Use row 1 as headers and Use column A as labels when those cells really contain headings and category names.
Try Switch rows/columns if your data is arranged with series in rows instead of columns, or vice versa.
If the range includes separate blocks, check that each block is intentional and that labels line up with the values.

Changing the data range does not change the underlying spreadsheet values. It only tells the chart which cells to interpret. If you are unsure, select the small, clean table you want to visualize before using Insert > Chart; Sheets will make an initial chart from that selection, which you can then refine in Setup.

Make sure the values are usable

A cell can look like a number while being stored as text. This can happen after copying data from a website or importing a CSV, particularly when decimal or thousands separators differ from the spreadsheet’s locale. A currency symbol or other unexpected characters can also interfere with how a value is read. Select a questionable cell and inspect its contents in the formula bar; also check whether the displayed value is left-aligned or has a warning marker, though alignment alone is not definitive.

With a candidate value in B2, enter =ISNUMBER(B2) in another cell to check whether Sheets recognizes it as numeric. For instance, if B2 contains the text string “125” rather than the number 125, the check returns FALSE. Convert or re-enter the value as a number, or use an appropriate import or cleanup method, then confirm the chart includes that cell.

Look for formulas that return an empty string as well. A cell that appears empty because a formula displays nothing is not a visible data point. If every cell in a plotted series is empty, the chart has no values to show. Similarly, a column of labels such as “low,” “medium,” and “high” is not a numeric series for a standard column or line chart. You may need to encode categories as numbers or choose a chart type that suits the actual information.

Consider blank cells, filters, and hidden data

Blank rows inside a data range can interrupt a line or make a table harder to interpret, even when they do not remove the other plotted values. Remove accidental blank rows between records when practical. If a range is populated only in rows excluded by a filter, check the chart’s Setup options for Include hidden / filtered data, if that option is available in the editor. The setting determines whether hidden or filtered-out source rows are included.

Also check whether a filter view, filter, or manually hidden row is affecting the part of the table you expect to see. A chart that updates after you change a filter may be behaving as configured rather than losing its data. Test with a small visible range or temporarily clear the relevant filter to distinguish a filtering issue from a chart setup problem.

Do not assume that formatting is the same as data. White font, a custom number format, or conditional formatting can make values hard to see in the sheet, but those features do not generally erase the underlying cell contents. Check the values themselves and the chart’s series colors before rebuilding the chart.

Match the chart type to the table

A chart can have a valid range but still fail to communicate the data—or appear empty—if its type expects a different structure. Column, bar, and line charts commonly use one category column and one or more numeric series. A scatter chart needs numeric values for both its X-axis and its series. A pie chart is designed to show categories against a single series of values, not several unrelated series.

In the Chart editor’s Setup tab, try a basic column chart as a diagnostic when you have category labels and numeric values. If that chart shows marks but the original chart does not, the issue is likely the original chart type or its assignments rather than missing source data. Then choose a type that fits your question: a line chart for change over an ordered sequence, a bar chart for comparing categories, or a scatter chart for examining the relationship between two numeric variables.

For a scatter chart, check that the X-axis range contains numbers, not category words or dates that Sheets has interpreted as text. For a pie chart, confirm that the categories and values form a simple two-column table and that the values are suitable for the chart. A chart type can also be technically valid but visually unhelpful when it has too many categories or series; reducing the selected range can make the result easier to interpret.

Check axes, colors, and chart placement

If the chart has axes but no visible marks, inspect the scale and appearance before changing the source table. In Customize, open the relevant chart and axis sections to review the axis bounds, labels, and series appearance. A manually specified minimum or maximum can place values outside the visible plotting area. Resetting an unusual bound or using an automatic scale can reveal data that was present all along.

Open Customize > Series to check the series color and point or line styling. A white line on a white background, very small points, or a thin line can be difficult to see. If you have multiple series, select each one from the series control and check its settings. Also review Customize > Chart style for background and border choices. These appearance checks matter when the chart frame and axes are present but the actual data marks are not obvious.

Finally, make sure you are looking at the chart itself rather than an empty cell range beside it. A chart is a movable object in Google Sheets, so it can be positioned far from its source data or partly outside the area currently visible. Zooming out or using the sheet’s scroll bars can help locate it. If the chart object is visibly present but still empty, continue with its Setup and source cells rather than assuming it has disappeared.

A practical troubleshooting sequence

Use these checks in order to narrow down the cause without changing several things at once:

Click the chart and open Edit chart. Note whether it has axes, a legend, a title, or any marks.
In Setup, verify Data range, X-axis, and Series. Make sure the range includes actual data rows, not just headers.
Inspect a few source cells. Confirm that numeric measurements are numbers and are not blank strings, error results, or text labels.
Try a simple chart type that matches the table, such as a column chart for categories and numeric values.
Check filters and hidden rows, and review Include hidden / filtered data if the setting appears.
If axes appear but marks do not, inspect axis bounds, series visibility, and chart colors in Customize.
Test a small, known-good range in a new chart. If that works, compare its range and assignments with the original chart.

Testing a small range is especially useful because it separates a chart problem from a data problem. For example, create a temporary two-column table with a few category labels and ordinary numeric values, select it, and choose Insert > Chart. If that chart displays, the original chart’s data range, cell contents, filters, or chart type is the more likely cause. You can delete the temporary chart and test data when finished.

When to refresh, rebuild, or compare with Excel

If the chart settings and values look correct but the display has not updated, wait briefly for Sheets to finish syncing, then reload the browser tab. Before reloading, make sure pending edits have been saved or that the connection is working; a temporary connection problem can make a spreadsheet appear stale. Reopening the file in another supported browser can help identify a browser-specific display issue, but it will not fix an incorrect data range.

Rebuilding a chart is reasonable when its settings have become confusing: select the intended source range, use Insert > Chart, and configure the new chart in Setup. Keep the original until the replacement works if its formatting matters. Google Sheets and Microsoft Excel both create charts from selected cell ranges, but their chart editors and menu paths differ. Instructions for Excel’s ribbon should not be followed as if they were Google Sheets steps; use Sheets’ Chart editor and menu names in a browser.

Frequently Asked Questions

Why is my Google Sheets chart blank even though the cells have data?
Check whether the chart’s Data range includes those cells and whether the values are recognized as numbers. Also inspect filters, chart type, series assignments, and axis bounds. Visible text in a cell is not always a numeric value that a chart can plot.

Why does my chart show axes but no bars or lines?
The chart may have an empty or incorrectly assigned series, values stored as text, or axis limits that exclude the data. Open Edit chart > Setup to inspect the series, then check Customize for unusual axis bounds and series styling.

Can blank cells make a Google Sheets chart disappear?
Blank cells can leave gaps or contribute no plotted points, but a few blanks do not normally explain why all other valid data is missing. If the whole series is blank—or formulas display empty strings throughout it—the chart has no visible values to draw.

How do I include filtered or hidden rows in a chart?
Open the chart editor and inspect Setup for Include hidden / filtered data, if the option is available for that chart. Turn it on if you want those source rows included; otherwise, the chart may reflect the visible data only.

Should I delete and recreate a blank chart?
Not as the first step. Correcting the data range or series often fixes it without losing formatting. Recreate the chart only after checking its setup, or use a new chart from a small, known-good range to identify whether the original configuration is the problem.

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.