Chart & Visualization Issues

Fix a Blank White Excel Chart in Desktop Excel

Camila MilosovichCamila Milosovich Nov 12, 2026 869 views

Question details

The user needs to restore an Excel chart that appears as a blank white area in the desktop application but works correctly in Excel for the web.

Fix a Blank White Excel Chart in Desktop Excel
Product
Microsoft Excel desktop application
Device & OS
not provided
Scenario
The user opens a workbook in desktop Excel and needs the chart to render normally.
Observed behavior
The chart area is a blank white square in desktop Excel, while the same chart displays correctly in Excel for the web.
Before you start

Open the workbook in Excel for the web first to confirm that the chart data and layout are intact. Then save a separate local copy before changing chart ranges, display settings, or calculation options in desktop Excel.

Solution 1Recommended

Verify the chart data range, numeric values, and series formatting

Use this method when the chart object is present but no columns, lines, markers, or labels are visible.

A blank chart can result from an incorrect source range, percentage values stored as text, hidden series, or chart elements formatted with white fills or lines.

1
Select the blank chart

In desktop Excel, click the blank white chart area to display the Chart Design and Format tabs on the ribbon.

2
Confirm the source data

Go to Chart Design > Select Data and verify that the Chart data range and each Series values range point to cells containing the intended data.

3
Check that percentages are numbers

Select the source cells, then go to Home > Number and apply Percentage or General. If values are left-aligned or have a green error indicator, use the warning button or Data > Text to Columns > Finish to convert text percentages to numbers.

4
Show hidden data and series

Go to Chart Design > Select Data > Hidden and Empty Cells, then enable Show data in hidden rows and columns if the chart source is hidden. In Select Data, make sure no required series has been removed.

5
Inspect chart colors

Click a chart series, then open Format Data Series > Fill & Line. Choose a visible fill or line color rather than white, and confirm that transparency is not set to 100%.

Verify the chart data range, numeric values, and series formatting
Expected result: After the ranges contain numeric data and the series use visible formatting, the chart should render again in the desktop workbook.
Free Microsoft Office alternative

Open and Edit Excel Chart Workbooks with WPS Spreadsheet

If desktop Excel continues to render charts incorrectly, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and straightforward migration for Excel workbooks. Open the file in WPS Spreadsheet to review the chart data, adjust series and formatting, and continue working with compatible spreadsheet files.

Create and edit charts from worksheet data in WPS Spreadsheet.Open and save Microsoft Excel XLSX and XLS workbook formats.Use a familiar ribbon-based interface for easier migration from Excel.Work with a free, lightweight office suite for everyday spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my chart work in Excel for the web but appear blank in desktop Excel?

The workbook data may be valid, while desktop Excel has a local rendering, graphics-driver, add-in, or calculation issue. Check Chart Design > Select Data first, then test Excel in Safe Mode and update Office.

How can I tell whether percentage values are stored as text in Excel?

Text percentages are often left-aligned and may show a green error indicator. Select the cells and use Home > Number to apply Percentage, or use Data > Text to Columns > Finish to convert text values to numbers.

Where can I check whether an Excel chart series is hidden?

Select the chart and go to Chart Design > Select Data. Review the listed series and use Hidden and Empty Cells to control whether data in hidden rows and columns is plotted.

How do I turn off hardware graphics acceleration in Excel?

Go to File > Options > Advanced, find the Display section, select Disable hardware graphics acceleration if available, and restart Excel. The option may not appear in all Excel versions.

What should I do if only one workbook has a blank chart?

Create a new workbook, copy the source data, and create a chart through Insert > Charts. If the new chart displays normally, replace the original chart object or rebuild the affected workbook section.