If an Excel chart is missing or blank, first check that Excel is set to show objects: in Microsoft 365 for Windows, go to File > Options > Advanced and, under For objects, show, select All. Then check that the chart is not hidden and that its source range contains the data you expect. These checks resolve many cases, but filters, chart type, and worksheet display settings can also make a chart appear empty.
Start with the chart’s visibility
First determine whether the chart is absent from the worksheet or present but showing no plotted data. Click the area where you expect it to be, or look for its name in the Selection Pane. On the Home tab, choose Find & Select > Selection Pane. If a chart is listed but hidden, use the eye icon beside its name to show it. You can also select the chart in the pane and check whether it has been moved or resized until it is difficult to see.
Excel has a workbook setting that can hide drawing objects, including charts, shapes, and pictures. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Scroll to the Display options for this workbook section, find For objects, show, and choose All. The other choices can hide objects or show placeholders instead. If you have several workbooks open, make sure you are changing the setting for the workbook containing the chart.
On a Mac, the Windows File > Options route does not apply. Check the chart’s visibility and the Selection Pane first; Excel for Mac has different application preferences and ribbon layouts. In Excel for the web, some desktop display and object-management controls may be unavailable, so opening the workbook in the desktop app can help with diagnosis.
Check whether the chart is blank or missing
A blank chart usually means Excel can display the chart object but cannot find usable values in its plotted series. Select the chart, then choose Chart Design > Select Data. The Select Data Source dialog shows the chart data range and the series listed in the legend entries. Confirm that the range includes the intended labels and numeric values. If the source range is wrong, select the correct cells in the worksheet or edit the range in the dialog.
For example, suppose a table has months in A2:A7 and sales in B2:B7, but the chart source points to A2:A7 alone. Excel may have category labels but no numeric series to plot. If the source points to an empty area, the chart can look entirely blank. Also check whether the data was moved, deleted, or replaced after the chart was created.
In Select Data, inspect the series one at a time if the chart should contain multiple lines or columns. Make sure each series name refers to the correct heading and its series values refer to the numeric cells. The horizontal axis labels should point to the intended categories, such as dates or product names. Avoid selecting entire columns without a reason: extra headings, notes, or unrelated data can make a chart confusing or cause Excel to interpret the range unexpectedly.
Look for values Excel cannot plot as expected
Charts need values that suit the selected chart type. Numbers stored as text may not behave like numeric measurements, and cells containing labels or error values are not ordinary plotted numbers. Check a few source cells: a number aligned or formatted unusually may have been imported as text. Re-entering a value, converting the imported column to numbers, or cleaning the source data can restore the series. Do not simply remove cells until you have checked whether they contain information needed elsewhere.
Dates can cause a related problem. If dates are stored as text, Excel may treat them as category labels rather than a continuous date axis. That can be appropriate for a simple category chart, but it may prevent the spacing or time scale you expect. Verify that the source cells are actual Excel dates and, if needed, use an axis type suited to the data. The available axis options depend on the chart type.
Empty cells do not always mean the same thing visually. A line chart may show gaps where values are missing, or connect across gaps depending on its settings. Select the chart and choose Chart Design > Select Data > Hidden and Empty Cells to review the available treatment of empty cells. That dialog also has an option to show data in hidden rows and columns. The wording and available choices can vary with chart type and Excel version.
Check chart filters and hidden worksheet data
A chart can exist and have a correct source range yet show only some series or categories because its filters are active. When selected, many Excel charts display a Chart Filters button near the chart. Open it and check both the series and categories, then apply the changes. For a chart without that button, use Chart Design > Select Data to inspect which series are included.
Worksheet filters can also change what you see in the chart, particularly when the chart is set not to plot data in hidden rows or columns. A filtered table may leave fewer visible points than expected. Review the table’s filter arrows and clear filters temporarily to see whether the missing categories return. If the chart should include filtered-out rows, inspect Hidden and Empty Cells in the Select Data dialog and enable Show data in hidden rows and columns if that option is available and appropriate.
Be careful not to confuse hidden data with deleted data. Clearing a table filter changes which rows are displayed; deleting rows changes the underlying data. If a chart is used in a report, check its filters and source range before concluding that the data itself has disappeared.
Check the chart type and axis settings
The chart type can make valid data look invisible or nearly invisible. A line chart may be hard to read for a single category, while a pie chart needs values that can be divided into slices. A scatter chart expects paired numeric values for its x and y coordinates. If the data layout does not match the chart type, select the chart and use Chart Design > Change Chart Type to choose a better fit.
Axes can also hide a series. If the vertical axis bounds were set manually, new values outside those bounds may be clipped. Right-click the axis, choose Format Axis, and check whether Minimum and Maximum are set to fixed values instead of Auto. For example, a chart with values from 0 to 100 will not show a new value of 500 if the axis maximum remains fixed at 100. Resetting the bound to Auto may make the point visible.
For a combination chart with series on different scales, one series may appear flattened against the axis. In Change Chart Type, review the chart types assigned to each series and whether a secondary axis is appropriate. Use a secondary axis only when it makes the relationship easier to interpret; it changes the visual scale and can mislead if readers assume both series share one scale.
Inspect chart size, placement, and worksheet tabs
A chart may be present but outside the visible worksheet area, behind another object, or reduced to a tiny size. The Selection Pane is useful because it lists objects even when they are difficult to select directly. Choose a listed chart, then use the sizing handles to enlarge it or drag it into view. If another shape covers it, reorder the objects from the pane or use the available bring-forward and send-backward commands.
Check whether the chart is on a separate chart sheet rather than embedded in a worksheet. A chart sheet has its own tab and displays the chart as the sheet content. Look across the workbook tabs, including hidden tabs if you have access to them. To unhide a worksheet, right-click a visible sheet tab and choose Unhide, then select the sheet. A chart sheet is not the same as a hidden chart object on a regular worksheet.
Zoom level and window layout can make a chart seem missing, especially in a workbook with a large used range. Use the worksheet’s scroll bars and return the zoom to a readable level. If the chart is meant to move and size with cells, its placement behavior can be reviewed in the chart’s Format Object or Size & Properties controls; the precise pane labels may vary by Excel build.
Rule out workbook and display problems
If the chart appears in one copy of the file but not another, compare the files and confirm that you opened the intended workbook. A workbook opened in Protected View may restrict editing until you trust the source and choose Enable Editing, when appropriate. If the chart was created with a newer feature or chart type, an older Excel version or another spreadsheet app may not render it identically. Microsoft 365 for Windows is the reference environment for the steps here.
If other charts or visual objects are also missing, the issue is more likely to involve object display settings or the workbook environment than one chart’s data. Save a separate copy before making broad repairs. Close and reopen Excel, confirm Microsoft 365 is up to date through File > Account > Update Options > Update Now, and check whether the same workbook displays correctly on another supported device or in Excel for the web. Differences between apps can help isolate the cause, although they do not prove that the original file is damaged.
Do not delete and rebuild a chart as the first response. Recreating it can lose formatting, labels, and custom axis settings. Once you have checked visibility, the source range, filters, and chart type, rebuilding may be reasonable if the chart object itself is corrupted or its settings are too difficult to repair. Keep the original workbook copy until the replacement has been checked.
A reliable troubleshooting order
Use this sequence to narrow down the problem without changing several settings at once:
- Confirm whether the chart is absent, hidden, or visible but blank.
- Check File > Options > Advanced > For objects, show on Windows, and inspect the Selection Pane.
- Use Chart Design > Select Data to verify the source range, series, and category labels.
- Check that source values are usable numbers or dates, and review chart filters and worksheet filters.
- Inspect hidden rows and columns, empty-cell settings, chart type, and axis bounds.
- Check chart placement, workbook tabs, Excel version, and whether the problem occurs in another copy or app.
After each change, look at the chart again. This makes it easier to identify the setting that caused the problem and reduces the risk of altering unrelated parts of a report.
Frequently Asked Questions
Why is my Excel chart blank even though the data is there?
A blank chart commonly has an incorrect source range, no included numeric series, or filtered-out categories. Select the chart and open Chart Design > Select Data. Check the range and series values, then inspect chart and worksheet filters.
Why did my Excel chart disappear?
The chart may be hidden in the Selection Pane, moved off-screen, on a different sheet, or hidden because Excel is set not to show objects. On Windows, check File > Options > Advanced and set For objects, show to All.
How do I show a chart that is hidden in Excel?
On the Home tab, choose Find & Select > Selection Pane. If the chart appears in the list with visibility turned off, select its eye icon. If it is not listed, check the workbook’s object-display setting and the other sheet tabs.
Why does my chart not update when I change the data?
Check that the edited cells belong to the chart’s source range and that the affected series has not been filtered out. If you added rows outside the original range, update the source in Chart Design > Select Data or use a structured Excel table as the source so its range can expand with added rows.
Can hidden rows still appear in an Excel chart?
Yes, depending on the chart’s settings. Select the chart, open Chart Design > Select Data > Hidden and Empty Cells, and review Show data in hidden rows and columns. If the option is off, hidden or filtered data may not be plotted.
Related
- Excel Work Timesheet Template: Build One That Adds Work Hours
- Excel Won’t Group Dates in a PivotTable? Fixes That Work
- Excel Table Names: Where to Find, View, and Change Them
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- K in Graph Theory: Complete Graphs, Meaning and UsesIn graph theory, Kn usually denotes the complete graph on n vertices: a graph in which every pair…
- Excel Line Chart With Two X-Axes: Setup and AlternativesExcel can display a secondary horizontal axis on some charts, but a standard line chart does not give…
- PowerPoint Org Chart: Make All Boxes the Same SizeYes. For an org chart made from separate shapes, select the boxes and enter matching Height and Width…
- Excel Pivot Table Date Filter by Month: Steps and FixesTo filter an Excel PivotTable by month, place a real date field in Rows, open its field dropdown,…
- Radar Chart Excel Format: Setup and Styling GuideIn Microsoft Excel for Microsoft 365 on Windows, select a table with category labels and one or more…
- Excel Sparklines: Can You Use Multiple Data Ranges?In Excel, each sparkline shows one sequence of values in one cell; it does not combine several separate…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.