If a chart is missing or blank in Excel for Microsoft 365 on Windows, first check whether Excel is hiding objects: go to File > Options > Advanced, find Display options for this workbook, and set For objects, show to All. If the chart frame is visible but has no plotted data, select it and check Chart Design > Select Data for the correct source range and series.
Identify what “not showing” means
Excel charts can fail in several different ways, and the right fix depends on what you see. A chart may be completely absent, present as an empty rectangle, visible but missing some categories or series, or present on the sheet but outside the area you are looking at. A chart can also appear blank because its source data is filtered, hidden, or empty. Distinguishing these cases saves time: a hidden chart object needs a different fix from a chart whose source range no longer contains usable values.
Start by checking whether the chart is on the current worksheet or on a separate chart sheet. Look at the sheet tabs, use the workbook’s navigation or sheet list if available, and inspect nearby areas of the worksheet. If other shapes and pictures are missing too, that points toward an object-visibility setting rather than a problem with the chart’s data.
- No chart frame at all: check object visibility, the active sheet, and whether the chart was moved or deleted.
- Frame but no bars, lines, or points: inspect the source range, filters, and whether the source contains chartable values.
- Only some data is missing: check chart filters, hidden rows or columns, and the selected series.
- Chart appears in another file or on another computer: check whether it is an embedded chart, a linked object, or a chart stored on a separate sheet.
Check whether Excel is hiding chart objects
In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Scroll to Display options for this workbook, choose the workbook if the setting offers a workbook selector, and under For objects, show, select All. If the setting is set to Nothing (hide objects), charts, pictures, and other objects can disappear from the worksheet even though their data and object definitions remain in the file. Changing the setting to All can make them visible again.
This setting applies to more than charts. If pictures or shapes vanish at the same time, it is a particularly useful clue. On Excel for Mac, the Windows Options dialog is not used; look in Excel > Settings (or Preferences in some releases) > View for object-display settings. The exact labels can vary by release. Excel for the web has a different interface and does not expose every desktop setting, so open the workbook in the desktop app if you cannot find the relevant control.
Also check whether the worksheet itself is hidden. Right-click a visible sheet tab and choose Unhide if that command is available, then select the sheet that contains the chart. If the chart is on a chart sheet, it will have its own sheet tab rather than appearing as an object inside a regular grid. A hidden worksheet and a hidden chart object are separate issues.
Verify the chart’s source data
If the chart frame is visible but empty or incomplete, select it and choose Chart Design > Select Data. The Chart data range box shows the cells Excel is using, while the Legend Entries (Series) and Horizontal (Category) Axis Labels areas let you inspect the individual series and labels. A range that points to the wrong sheet, an accidentally shortened range, or cells that have been cleared can leave a chart with nothing useful to display.
Check the source table itself. A typical chart needs a row or column of numeric values and, where useful, adjacent labels. For example, a table with month names in column A and sales amounts in column B can be charted by selecting both columns, including their headers. If the values in column B were imported as text, Excel may not plot them as expected. Check that the cells contain numbers rather than text that merely looks numeric, and confirm that the intended data was not replaced by blanks or error values.
When a chart uses separate ranges, verify both the series values and category labels. In Select Data, you can choose a series and use Edit to check its name and values. Make sure the references cover the same intended number of rows or columns. If you add rows below a fixed source range, the new data may not be included automatically. Excel tables often expand as rows are added, but charts based on ordinary cell ranges may need their source range updated.
Look for filters and hidden rows or columns
A worksheet filter can hide rows from view, and a chart may consequently omit their values. Select the chart and look for the Chart Filters button beside it, if Excel displays that button for the chart type. Open it to review which series and categories are selected, then choose Apply if you change the selections. A filter in the source table is a different control: clear or adjust the table’s filter and see whether the missing categories return.
Excel charts do not necessarily display values in hidden rows or columns. To check the chart’s setting, select the chart, choose Chart Design > Select Data, and in the dialog choose Hidden and Empty Cells. If the option to show data in hidden rows and columns is available, select it when the chart should include those values. This can be important when someone hides columns to simplify a worksheet but still wants the chart to represent the complete data set.
The same dialog lets you choose how empty cells appear: as gaps, zeros, or connected data points, depending on the chart and options shown. A gap may be intentional for missing observations; connecting across gaps may suggest a continuous trend where there is no recorded value. Do not treat blanks and zeroes as interchangeable. A true zero is a measured value, while a blank may mean no observation, and the choice can change how readers interpret the chart.
Find a chart that has moved or become hard to select
A chart object can be moved, resized, or partly covered by another object. Check the area around the data and scroll through the worksheet; also consider whether the worksheet is zoomed in or out. If you suspect an object is present but difficult to select, go to Home > Find & Select > Selection Pane. The pane lists objects on the sheet, allowing you to select a chart by its listed name and, where available, toggle its visibility. This can reveal an object that is behind another shape or located in an unexpected place.
After selecting the chart through the pane, use the arrow keys to move it into view or adjust its size by dragging its handles. If worksheet rows or columns were hidden or resized, the chart may also be difficult to see. To control how it behaves as cells change, right-click the chart, choose Format Chart Area, and inspect Size & Properties for the available placement options. These settings determine whether the chart moves or resizes with cells; they do not repair a missing data series.
If you can select the chart but cannot change it, the worksheet or workbook may be protected. Protection can restrict editing objects without making the chart’s source data disappear. Check Review for protection controls and follow the workbook owner’s instructions before changing protection. A password-protected workbook should not be treated as though its chart were simply hidden.
Repair or recreate a chart safely
If the source range is wrong, correcting it is usually better than rebuilding the chart. Use Chart Design > Select Data to adjust the range, add a series, remove an unintended series, or update category labels. If the chart is severely damaged or its configuration is unclear, create a new chart from a clean selection of the source data and compare the result before deleting the original. That preserves the chance to recover its formatting or settings.
- Confirm the source values and labels are present and arranged consistently.
- Select the intended range, including headers where appropriate.
- Choose Insert and select a suitable chart type, or use Insert > Recommended Charts to review options.
- Check that the new chart displays the intended series and categories, then add titles or formatting as needed.
For example, if a monthly sales chart shows only January through June after July and August were added, select the chart and inspect its data range. If the range stops at June, expand it to include the new rows. If the range already includes all eight months, check the chart filters and whether the later rows are hidden or contain text instead of numbers. This sequence helps isolate the cause instead of making several unrelated changes.
Check calculation, compatibility, and file state
Charts based on formulas can appear out of date if the formulas have not recalculated, especially in a workbook set to manual calculation. On Windows, check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook. Recalculate the workbook and then see whether the chart changes. Calculation settings affect formula results; they will not restore a chart object that has been hidden or deleted.
If the chart is missing only in Excel for the web or in a non-Excel viewer, open the file in the desktop version of Excel and compare it. Some features, chart editing controls, and display settings differ between Excel for Windows, Mac, and the web. If a chart was copied from another program or uses linked data, its appearance may also depend on the linked source or on features the viewer does not support. Keep the original workbook intact while investigating, particularly if it contains external links or specialized chart formatting.
When the issue began after a crash or an unexpected close, check for a recovered copy before recreating the chart. Use Excel’s Document Recovery pane if it appears, or look for the latest saved version through the workbook’s normal file-history or backup process. Saving a corrected copy under a new name is a cautious way to preserve the source while confirming that the chart remains visible after closing and reopening the file.
Frequently Asked Questions
Why is my Excel chart blank but the chart area is visible?
Common causes include an incorrect source range, values stored as text, filtered categories, or hidden rows and columns. Select the chart and check Chart Design > Select Data, then review chart filters and Hidden and Empty Cells.
How do I make an Excel chart show hidden rows?
Select the chart, choose Chart Design > Select Data, then choose Hidden and Empty Cells. Turn on the option to show data in hidden rows and columns if it is available. The chart will then include those values even while the worksheet rows or columns remain hidden.
Why did my chart disappear after I opened the workbook?
Check File > Options > Advanced > Display options for this workbook and set For objects, show to All. Also confirm you opened the correct worksheet and that the chart was not moved to a separate chart sheet or hidden sheet.
Why does my Excel chart not include new rows?
The chart may use a fixed cell range that ends before the added rows. Select the chart, open Chart Design > Select Data, and check the range. Expand it to include the new data, or use an Excel table as the source when you want the data range to grow as rows are added.
Can I recover a chart that was deleted?
If the deletion was recent, use Undo before making other changes. Otherwise, check a saved earlier copy, workbook version history, or a recovered file. If none is available, you may need to create a new chart from the remaining source data; its original formatting may not be recoverable.
Related
- Append Tables in Excel Without Power Query: Best Methods
- Align Excel Columns: Shortcuts for Text and Column Width
- Excel Filtered Rows: How to Copy and Paste Visible Cells
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: How to Remove Zero ValuesTo remove zero-valued results from an Excel PivotTable, open the drop-down for the row or column field, choose…
- Excel Chart Types: Uses, Examples, and How to ChooseExcel includes chart types for comparing categories, showing change over time, displaying parts of a whole, and exploring…
- Excel Bubble Chart Data Labels: Add and Format ThemTo add labels to an Excel bubble chart in Microsoft 365 for Windows, select the chart, choose Chart…
- How to Add a Trendline to a Google Sheets ChartTo add a trendline in Google Sheets, click or double-click the chart, open Customize > Series in the…
- View Pivot Table Fields in Google SheetsTo view pivot table fields in Google Sheets, click any cell inside the pivot table; the Pivot table…
- Data Pivot Chart: Meaning, Uses, and How It Works in ExcelA data pivot chart—usually called a PivotChart in Microsoft Excel—is an interactive chart linked to a PivotTable. It…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.