Fix a Blank White Excel Chart in Desktop Excel
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.

- 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.
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.
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.
In desktop Excel, click the blank white chart area to display the Chart Design and Format tabs on the ribbon.
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.
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.
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.
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%.

Refresh calculation and disable hardware graphics acceleration
Use this method when the chart data is correct but desktop Excel still fails to draw the chart.
Test the workbook in Safe Mode and recreate the chart if needed
Use this method to determine whether an Excel add-in, workbook corruption, or file-specific chart object is causing the blank display.
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.

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.




