How to Fix Excel Chart Data Labels Showing Blank Bars
Question details
The user needs to fix an issue where applying 'Value From Cells' to chart data labels results in blank bars or an empty chart.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Adding custom data labels to a chart series using the 'Value From Cells' feature.
- Observed behavior
- Chart data labels appear as blank bars, or the entire chart becomes blank due to incorrectly applied label ranges or source values being stored as text.
Ensure your chart's source data is visible and not hidden by active filters, as hidden rows can sometimes cause chart elements and labels to appear blank.
Re-apply Data Labels and Select Value From Cells
This is the most effective method to clear referencing glitches and ensure custom data labels map perfectly to your intended cell range.
When data labels are applied incorrectly to multiple series at once, the chart engine can fail to render them. Removing all labels and applying them one series at a time resolves this mapping conflict.
Click on your chart to select it, click the 'Chart Elements' (plus icon) next to the chart, and uncheck 'Data Labels' to clear the corrupted labels from all series.
Check the 'Data Labels' box again in the Chart Elements menu to apply default value labels to your data series.
Right-click the newly added data labels on one of your chart series and select 'Format Data Labels' from the context menu.
In the Label Options pane, check the box for 'Value From Cells'. A Data Label Range dialog box will appear.
Highlight the complete cell range that contains your custom labels on the spreadsheet and click 'OK'. Repeat this process for each individual series.

Convert Text-Formatted Source Values to Numbers
Use this solution if your source values or years are stored as text, which prevents the chart from reading the data properly.
Format Data as an Excel Table
Formatting your data as a structured Excel Table ensures that chart ranges and labels expand automatically without displaying blank bars when new rows are added.
Create and Manage Custom Chart Labels in WPS Spreadsheet
WPS Spreadsheet provides a highly intuitive and robust chart editor. You can easily assign custom cell ranges to your data labels without encountering blank bar glitches, making data visualization a breeze.
- 1. Insert a chart: Open your workbook in WPS Spreadsheet, select your data range, navigate to the 'Insert' tab, and choose your preferred chart type.
- 2. Add data labels: Click on the chart, click the 'Chart Elements' icon, and check 'Data Labels'.
- 3. Apply values from cells: Right-click the labels, choose 'Format Data Labels', check 'Value From Cells', and highlight your custom label range.

Frequently Asked Questions
Why do my Excel data labels show cell references instead of the actual values?
This usually happens if the cell formatting is incorrect or if the 'Value From Cells' box wasn't checked properly in the Format Data Labels pane. Ensure you select the range through the Data Label Range dialog prompt rather than typing it manually into the label.
How do I make my chart ignore blank cells completely?
Right-click your chart and choose 'Select Data'. Click the 'Hidden and Empty Cells' button at the bottom left of the dialog box, and choose how you want empty cells to be handled (e.g., 'Gaps' or 'Zero').
Can I use formulas directly inside individual chart data labels?
Yes. To link a single data label to a formula, click the data label twice (to select just that specific label), click inside the formula bar at the top of the screen, type '=', and then click the cell containing your formula.




