Excel Chart Data Labels Missing or Overlapping: 6 Fixes

Two different problems bring people to this page. Either your labels aren’t showing up at all, or they’re showing up in a colliding, unreadable pile. Both are quick to fix, and both are usually caused by a default Excel setting rather than anything broken.

Fixes 1–3 handle missing labels. Fixes 4–6 handle overlapping ones. Jump to whichever matches what you’re staring at.

Missing labels

Fix 1: They were never turned on

Excel doesn’t add data labels by default — you have to ask for them. Click the chart, click the Chart Elements button (the green + that appears to the right), and check Data Labels. That’s it for most people; the values appear on every point.

If checking the box does nothing, the chart may have labels set to an invisible position or with no content selected — that’s the next fix.

Fix 2: Labels are on, but showing nothing (or the wrong thing)

If labels are enabled but blank, or they’re showing the category when you wanted the value, the content settings are off. Right-click any label, choose Format Data Labels, and look at the Label Contains section.

Check the boxes for what you actually want on the chart — Value is what most people are after, but you can also show Category Name, Series Name, or Percentage (useful on pie charts). If every box is unchecked, the labels exist but display nothing, which looks exactly like missing labels.

Fix 3: You want labels from a different column

A genuinely useful feature almost nobody knows about: your labels don’t have to be the plotted values. Say you’re charting revenue but want each bar labeled with the region name, or with a custom note. In Format Data Labels, check Value From Cells, then select the range holding your label text. Excel pulls the labels straight from those cells.

This is the clean way to put context on a chart without cluttering the axis. It’s also how you get a waterfall chart to show running totals rather than just step values.

Overlapping labels

Now the opposite problem: labels are showing, but they’re on top of each other. This is almost always a pie chart or a dense column chart with too many points crammed into too little space.

Fix 4: Turn on leader lines (pie and doughnut charts)

On pie charts, Excel uses a Best Fit position by default, moving labels inside or outside slices to avoid collisions as best it can. When slices are small, that isn’t enough and labels pile up outside the pie.

The fix is leader lines — thin connectors that let you drag a label away from its slice while keeping the visual link. In Format Data Labels, check Show Leader Lines. Then double-click a single crowded label to select just that one, and drag it clear. Excel draws the connector automatically.

Honest caveat: leader lines add their own visual clutter. On a pie with more than five or six slices, the better move usually isn’t better labeling — it’s a different chart. A bar chart labels cleanly with no acrobatics at all, which is one of several reasons pie charts are overrated. (Our chart chooser makes that case in full.)

Fix 5: Make more room, or make labels smaller

Two blunt but effective fixes for crowded column and bar charts. First, enlarge the chart: drag its corner outward, and Excel gets more room to place labels without overlap. Second, shrink the label font — select the labels and drop the font size a point or two. On a chart with a dozen columns, going from 11pt to 9pt often clears the collisions entirely.

Fix 6: Stop labeling everything

This is the fix nobody wants to hear, and it’s the right one more often than the others. You do not need a label on every data point. A line chart with 40 points labeled is unreadable noise; a line chart with the first, last, and peak points labeled tells the story instantly.

To label selectively, click once on the data labels to select the whole set, then click a second time on a single label to select just that one — now you can delete the individual labels you don’t need, or add one to a bare point. Label the values that carry meaning and delete the rest. The chart gets more readable, not less informative.

A quick word on when to label at all

The goal of a data label is to answer a question the axis can’t. If the reader can get the number accurately enough off the gridlines, the label is redundant and you’re just adding ink. Reach for labels when precise values matter (a KPI number, a total, a surprising outlier) and skip them when the shape of the data is the point. Fewer, well-chosen labels beat a wall of numbers every time.

The working file below has a crowded pie and a bare column chart each paired with a fixed version, so you can see leader lines and selective labeling applied to real charts rather than in the abstract.

FAQ

Why won’t my data labels show up even after I check the box? The label content is probably empty. Right-click a label > Format Data Labels > Label Contains, and make sure at least one box (usually Value) is checked. Enabled-but-empty labels look identical to missing ones.

How do I show text from cells as my data labels instead of the values? In Format Data Labels, check “Value From Cells” and select the range holding your label text. Excel uses that text instead of (or alongside) the plotted numbers.

How do I stop pie chart labels from overlapping? Enable Show Leader Lines in Format Data Labels, then double-click individual crowded labels and drag them apart — the connector line keeps them linked to their slice. If you have more than about six slices, switching to a bar chart is usually the cleaner answer.

Can I put a label on just one point? Yes. Click the data labels once to select all of them, then click a second time on the single label you want. Now you can delete it, restyle it, or (from a bare point) add just that one. This is the key to selective labeling.

My labels show the wrong number entirely. The chart is likely showing stale values — the labels are reading old cached data. That’s a refresh issue rather than a label issue; see why Excel charts don’t update.

---

Fighting with the legend too, not just the labels? Missing, wrong, or won’t-update legends have their own fixes.