Excel Chart Blank or Not Displaying? How to Fix It

There’s a difference between a chart that’s missing some data and a chart that’s completely blank — an empty frame with axes and a legend but nothing plotted, or a chart that’s vanished from the sheet entirely. This page is about the second kind. (If your chart is showing but dropping some points, you want why a chart isn’t showing all its data instead.)

Four things cause a blank or invisible chart. Here they are in the order you should check them.

Cause 1: The chart is pointing at an empty or wrong range

The most common reason a chart is blank is the most obvious one, which is exactly why it gets overlooked: the source range has no data in it, or points somewhere it shouldn’t. This happens when you copy a chart to a new sheet and the reference breaks, when you delete the rows the chart was built on, or when a chart gets created before the data is pasted in.

Click the chart and look at the worksheet. If Excel doesn’t highlight any source cells — or highlights an empty block — that’s your answer. Right-click the chart, choose Select Data, and check the Chart data range field. If it’s empty, wrong, or pointing at a deleted range, reselect your actual data.

While you’re there, glance at the Legend Entries (Series) list on the left. If it’s empty, the chart has no series to plot, which is why you’re seeing bare axes. Add a series, or reselect the full range, and the chart fills in.

Cause 2: All objects are hidden (the Ctrl+6 trap)

This one catches people out because the chart isn’t broken at all — it’s been switched invisible along with every other floating object on the sheet. Excel has a setting that hides all objects (charts, shapes, images) at once, and it has a keyboard shortcut that’s easy to hit by accident: Ctrl+6.

If every chart and image on a sheet has disappeared simultaneously, this is almost certainly why. Press Ctrl+6 to toggle them back on.

To check or fix it properly, go to File > Options > Advanced, scroll to Display options for this workbook, and under For objects, show: make sure All is selected rather than Nothing. If it’s on Nothing, every object on the sheet is hidden regardless of the shortcut.

Cause 3: Graphics acceleration is glitching the render

If the chart exists — you can click where it should be, select it, even see its outline — but it renders as a blank white box or flickers in and out, the problem is usually hardware graphics acceleration fighting with your display driver. This is a rendering fault, not a data fault: the chart is fine, Excel just can’t draw it.

Go to File > Options > Advanced, scroll to the Display section, and check Disable hardware graphics acceleration. Click OK and, if needed, restart Excel. This forces Excel to render charts in software, which is slightly slower but reliable. Nine times out of ten a stubbornly blank-but-selectable chart comes back after this.

Cause 4: The chart is corrupted

If none of the above works and the problem is confined to one specific chart while others on the same sheet are fine, the chart object itself may be corrupted — usually after a crash, a bad copy-paste between workbooks, or a file that’s been through several format conversions.

There’s no elegant repair here. The fastest route is to rebuild: note the source range, delete the broken chart, select the data fresh, and insert a new one. If you’d spent time formatting the original, you can sometimes salvage the look by saving the old chart’s formatting as a template (right-click > Save as Template) before deleting it — though a corrupted chart won’t always cooperate. When it won’t, rebuilding from scratch is genuinely quicker than fighting it.

A quick corruption sanity check: save the workbook, close it, and reopen. A surprising number of “corrupted” charts are just a display state that a clean reopen resolves. Try that before you rebuild anything.

The order that saves time

Don’t skip around. Check the range first (Cause 1) because it’s the most common by a wide margin. If the whole sheet’s gone blank, it’s the Ctrl+6 toggle (Cause 2). If one chart selects but won’t draw, it’s graphics acceleration (Cause 3). Only when a single chart is broken and everything else is fine do you reach for the rebuild (Cause 4).

The working file below reproduces the two software-side causes — a chart with a broken range next to a corrected copy, and a demo of the objects-hidden toggle — so you can confirm the fix behaves the way this page describes before applying it to your own file.

FAQ

My chart shows the axes and legend but no bars or lines. Why? The source range is empty or misdefined. Right-click the chart > Select Data and check the Chart data range and the Series list. An empty series list means there’s nothing to plot, which produces exactly that empty-frame look.

All my charts and images vanished from the sheet at once. You’ve hit the hide-all-objects setting, usually via the Ctrl+6 shortcut. Press Ctrl+6 to bring them back, or set File > Options > Advanced > “For objects, show” to All.

The chart is there and I can select it, but it renders as a blank white box. That’s a graphics rendering glitch, not a data problem. Turn on File > Options > Advanced > Display > “Disable hardware graphics acceleration” and restart Excel.

Only one chart is blank and the rest are fine. That chart is likely corrupted. Save, close, and reopen the file first — that fixes many cases. If it’s still blank, delete it and rebuild from the source data; it’s faster than trying to repair the object.

My chart shows old data or won’t refresh — is that the same problem? No. A chart that displays but shows stale values is a refresh issue, not a blank-chart issue. See why Excel charts don’t update for that one.

---

Once your chart is displaying again, make sure it’s the right chart for your data — our chart chooser guide walks through which type fits which job.