Chart & Visualization Issues

Fix Excel Chart Data Labels Blank When Using Cell Values

WPS Editor Oct 9, 2026 869 views

Question details

User experiences blank data labels on Excel charts when trying to display values assigned from specific worksheet cells.

How to Fix Excel Chart Data Labels Appearing Blank from Cell Values

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating or editing a chart and using the 'Value From Cells' option to apply custom labels from a data range.
Observed behavior: The data labels appear completely blank on the chart, although they sometimes magically reappear after the workbook is saved and reopened.

Before you start

Ensure your workbook is saved and create a backup copy before adjusting chart data ranges or forcing global formula recalculations.

Solution 1Recommended

Force Recalculation and Refresh the Workbook

Use this solution when a known Excel rendering bug stops cell values from updating correctly on charts.

Sometimes Excel's graphical engine fails to fetch the updated values from cells in real-time, resulting in blank labels. Forcing a manual calculation or restarting the application often clears the cache and resolves this rendering glitch.

Save your current progress

Press Ctrl + S to save your workbook, ensuring no data is lost.

Force manual calculation

Press F9 on your keyboard to force Excel to recalculate all formulas and refresh data links in the active workbook.

Reopen the workbook

If the labels are still blank, close Excel completely, relaunch the application, and reopen your file. The chart labels should now render properly.

Force Recalculation and Refresh the Workbook

Quick Tip: If you constantly experience this issue, check if your Excel calculation options are set to 'Manual' under the Formulas tab, and change it back to 'Automatic'.

Solution 2

Re-select the 'Value From Cells' Range

Use this method to reset the link between the chart data labels and the source cells.

Solution 3

Check Source Cell Formatting and Font Color

Verify that the source cells are not hidden by formatting tricks or colored identically to the chart background.

Free Microsoft Office alternative

Create and Manage Charts Seamlessly with WPS Office

If Microsoft Excel continues to display blank chart labels due to caching bugs, try WPS Office. It provides a stable, lightweight, and completely free alternative with robust chart rendering and full compatibility for your Excel files.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbook directly without converting it.
3. Edit Chart Labels: Click on your chart and use the intuitive Chart Elements menu to seamlessly add and display data labels from cell values.

100% compatible with Microsoft Excel formats (.xlsx, .xls)Stable chart rendering without missing or blank data labelsLightweight and fast, even when handling complex datasetsFree to use with a familiar, user-friendly interface

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel chart data labels disappear when I print or save as PDF?

This can occur due to printer driver conflicts or graphic rendering bugs in Excel. Try updating your printer drivers, or save the file as a PDF using the 'Export' feature instead of 'Print to PDF'.

Can I use formulas in data labels directly?

Yes, you can link a single data label to a specific cell containing a formula. Click the data label twice (to select just that one), click in the formula bar, type '=', and click the target cell in your worksheet.

How do I show both the category name and cell value on a chart?

Right-click your data series, select 'Format Data Labels', and look at the Label Options pane. You can check multiple boxes, such as both 'Category Name' and 'Value' (or 'Value From Cells'), and choose a separator like a comma or a new line.

Excel & Data Problems