Chart & Visualization Issues

How to Fix Excel Chart Data Labels Showing Blank Bars

Anum MushtaqAnum Mushtaq Nov 10, 2026 870 views

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.

How to Fix Excel Chart Data Labels Showing Blank Bars
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.
Before you start

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.

Solution 1Recommended

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.

1
Remove existing data labels

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.

2
Re-enable data labels

Check the 'Data Labels' box again in the Chart Elements menu to apply default value labels to your data series.

3
Open Format Data Labels pane

Right-click the newly added data labels on one of your chart series and select 'Format Data Labels' from the context menu.

4
Enable Value From Cells

In the Label Options pane, check the box for 'Value From Cells'. A Data Label Range dialog box will appear.

5
Select the label range

Highlight the complete cell range that contains your custom labels on the spreadsheet and click 'OK'. Repeat this process for each individual series.

Re-apply Data Labels and Select Value From Cells
Tip: After adding 'Value From Cells', you can uncheck 'Value' or 'Show Leader Lines' in the same pane if you only want your custom text to appear.

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. 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. 2. Add data labels: Click on the chart, click the 'Chart Elements' icon, and check 'Data Labels'.
  3. 3. Apply values from cells: Right-click the labels, choose 'Format Data Labels', check 'Value From Cells', and highlight your custom label range.
Easily assign and manage cell ranges for chart data labels100% compatible with Microsoft Excel chart formatting and formulasIntuitive chart elements menu for quick and precise formattingFree and lightweight alternative for everyday data analysis
microsoft office alternative - wps office

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.