Excel Chart Labels: Add, Format, and Fix Them

In Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position to show values or other details beside the plotted data. To change what appears, right-click a label, choose Format Data Labels, and select the label content and appearance you need.

What Excel chart labels mean

“Chart labels” can refer to several different things. Data labels are attached to individual bars, points, slices, or other data marks; they can show values, category names, series names, or a combination. Axis labels identify positions along a chart axis, such as months along the bottom or dollar amounts along the side. Axis titles explain what an axis measures, while a chart title describes the chart as a whole. A legend identifies the series represented by colors or patterns.

These elements serve different purposes. For example, a column chart might use month names as horizontal-axis labels, revenue amounts as vertical-axis values, and data labels above each column to show the exact revenue. Adding every kind of label is not always helpful: labels that repeat information already obvious from the axes or legend can make a chart harder to read.

It is useful to be precise when troubleshooting. If the numbers beside bars are missing, you probably need data labels. If month names are missing, check the horizontal axis labels or the chart’s source data. If the chart has no explanation of what its vertical scale measures, add an axis title.

Add or remove data labels

For a standard chart in Excel for Microsoft 365 on Windows, use the ribbon or the chart’s on-chart controls:

Select the chart so the Chart Design and Format tabs appear.
Choose Chart Design > Add Chart Element > Data Labels.
Choose a position, such as Center, Inside End, Outside End, or Best Fit. Available positions depend on the chart type.

In many chart types, selecting a data series and clicking the plus sign (Chart Elements) beside the chart also lets you turn Data Labels on or off. To remove labels, clear Data Labels in that menu, or select a label and press Delete. Be careful: clicking once may select all labels in a series, while clicking a second time may select just one label. Deleting one selected label removes only that label; deleting the whole label set removes them all.

Excel for Mac has a similar Chart Design tab and Add Chart Element command, though ribbon layout can vary with window size and version. In Excel for the web, select the chart and use the chart ribbon controls when available; some chart-formatting choices are more limited than in the desktop app. If a specific label option is absent in the web version, open the workbook in desktop Excel.

Choose which information labels show

To control label content, right-click a data label and choose Format Data Labels. The Format Data Labels pane contains options that vary by chart type. Common choices include Value, Category Name, Series Name, and, for some chart types, Percentage. A pie chart, for example, can show category names and percentages; a column chart can show each point’s value. You can select more than one content option, but long combinations can crowd the plot.

For a pie chart, percentage labels are calculated from the plotted total, so a slice representing 25 out of 100 is 25 percent. If the chart displays multiple series or uses filtered data, check that the slices represent the population you intend to describe. A percentage label is not the same as a percentage stored in the source cells: it describes a slice’s share of the pie.

Label position is also a content decision. Outside End often suits small pie slices, while Inside End or Center can work for larger slices. Columns may be easiest to scan with labels above them, but labels inside a short column may overlap the axis. Try a different position before shrinking text or adding manual line breaks.

Use custom text from worksheet cells

When built-in labels do not say what readers need, Excel can use text from worksheet cells as labels for many chart types. This is useful for adding short descriptions, formatted values, or a value with a unit, without replacing the underlying numbers used to draw the chart.

Enter the desired label text in worksheet cells, with one label corresponding to each plotted point in the series.
Select the chart’s data labels, right-click, and choose Format Data Labels.
In Label Options, select Value From Cells, then select the worksheet range containing the labels and confirm the range.
Clear Value if you want to show only the custom text. Leave it selected if the custom text and plotted value should both appear.

For example, a chart could plot the numeric values 42, 56, and 61 while labels from adjacent cells read “Opening,” “Midpoint,” and “Close.” The labels do not change the plotted numbers. Keep the selected range aligned with the series order; a mismatch can attach a correct-looking description to the wrong point. If Value From Cells is not offered for a particular chart or series, use a supported chart type or add concise labels manually.

Format numbers and label appearance

Labels inherit useful formatting in many cases, but their number format may not match the message you want to convey. In the Format Data Labels pane, look for Number to choose a format such as Number, Currency, Percentage, or Date. You can set decimal places and, where offered, use the same number format as the source cells. For example, a source value of 12500 might be easier to scan as a currency amount with no decimal places than as a long unformatted number.

Formatting a data label does not necessarily change the underlying worksheet value. It changes how that value is displayed in the chart. Use consistent precision across comparable points: showing 4.2 for one bar and 4.23 for another can imply a difference in accuracy that the data does not support.

Font, fill, outline, and effects can be adjusted using the Format Data Labels pane or the chart’s formatting controls. Prioritize contrast and legibility over decoration. A label should remain readable against both the chart background and the data mark. If there are many points, reducing the number of labels or using a larger chart area is usually more effective than making every label tiny.

Change axis labels and add axis titles

Axis labels are not data labels. To change category names on the horizontal axis, edit the source cells that supply those categories or select the chart and use Chart Design > Select Data. In the Select Data Source dialog, use the Horizontal (Category) Axis Labels control and choose Edit to select a different cell range. The exact options can vary for chart types that use a value axis, such as an XY scatter chart.

To add an axis title, select the chart and choose Chart Design > Add Chart Element > Axis Titles, then choose the horizontal or vertical title option that fits the chart. Select the title box on the chart and type a concise description, such as “Units sold” or “Revenue (USD).” A title should include units when they matter; a scale marked 0 to 500 is ambiguous if readers cannot tell whether it means dollars, people, or kilograms.

If category labels appear in an unexpected order, check the source range and the chart’s axis settings before manually editing each label. For date axes, Excel may space dates according to time intervals rather than treat every date as a separate category. A text axis instead gives each listed category equal spacing. Choose based on whether the elapsed time between observations matters.

Common label problems and practical fixes

Labels overlap: Reduce the number of displayed points, widen the chart, shorten custom text, or try another label position. Rotating or shrinking text can help, but avoid making it difficult to read.
Some labels are missing: Excel may omit labels that do not fit, depending on chart type and position. Enlarge the chart or plot area, choose a different position, or label only the important points. Also check that labels have not been deleted individually.
Labels show the wrong values: Open Format Data Labels and verify whether Value, Category Name, or Value From Cells is selected. Then inspect the series and source range in Chart Design > Select Data.
Values display as dates or with too many decimals: Adjust Number formatting in the Format Data Labels pane. If the displayed result still seems wrong, inspect the underlying worksheet values and their number formats.
Axis labels are clipped: Make the chart wider or taller, enlarge the plot area, or shorten category text. Long labels can also be easier to read when displayed at an angle, if that option is available for the chart.
Labels disappear after data changes: Check whether the chart’s source range includes the new rows or columns. A chart does not always expand as expected, especially when its source is not an Excel table.

A useful diagnostic is to select the chart and then select the specific element you want to edit. The contextual ribbon and formatting pane will show whether you have selected the chart area, a data series, an individual point, an axis, or a label. Editing the wrong element is a common reason a setting appears to have no effect.

Make labels informative without clutter

Use labels when they save readers from estimating values or looking back and forth between a mark and a legend. They are especially useful in a small chart used on its own, in a presentation, or in a report where exact values matter. They are less useful when hundreds of data points would each need a label. In that situation, label a few meaningful points, provide a table, or use a chart type that makes the overall pattern clearer.

Keep wording brief and consistent. Include units where necessary, use a sensible number of decimal places, and avoid repeating a category name in every label if it is already printed on the axis. For a chart comparing several series, series names in the legend may be clearer than repeating the series name beside every point.

Data labels are visual annotations, not a substitute for checking the data. A chart can display a precise-looking number even when the source range is incomplete or the values are stored in the wrong units. Before sharing a chart, confirm that its title, axes, series, and labels describe the same data and that rounding does not conceal a meaningful difference.

Frequently Asked Questions

How do I show values on top of bars in Excel?

Select the chart, choose Chart Design > Add Chart Element > Data Labels, and select Outside End or another suitable position. If the chart has multiple series, choose the series carefully when you want to format only one set of bars.

How do I show percentages instead of values on a pie chart?

Right-click a pie-chart data label and choose Format Data Labels. Select Percentage and clear Value if you want percentages alone. Check the plotted categories and total to ensure the slices represent the intended whole.

Can I use my own words as chart labels?

Yes. Put one label per plotted point in worksheet cells, then select Value From Cells in the Format Data Labels pane and choose that range. Keep the cells in the same order as the chart’s series.

Why are my chart labels not updating when I change cells?

First check whether the chart series includes the changed cells, using Chart Design > Select Data. For labels linked through Value From Cells, verify that the label range points to the updated cells and still matches the plotted points.

What is the difference between a data label and an axis label?

A data label describes an individual plotted point, such as the value above a bar. An axis label identifies a position or scale on an axis, such as a month name or a dollar amount. They are set and formatted separately.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.