Add Data Labels to a Google Sheets Chart: Steps & Tips

To add data labels in Google Sheets, select the chart, open the chart editor, choose Customize > Series, and turn on Data labels. The labels appear on the chart without changing the values in your spreadsheet; available label types and positions depend on the chart type.

What data labels show

A data label places information about a plotted point directly beside or inside that point. In a column chart, for example, a label can show the sales value above each column. In a pie chart, labels can identify slices or show their values or percentages, depending on the options offered for that chart. This makes it easier to read specific values without repeatedly looking between the chart and its source table.

Labels are not the same as axis labels. Axis labels identify categories or measurement scales along the chart’s horizontal or vertical axes, such as months or dollar amounts. Data labels identify individual bars, points, slices, or other marks. A chart can have axis labels without data labels, or both at once.

Adding labels is a display choice, not a change to the underlying data. If a source value changes, a chart label based on that value updates with the chart. Labels do not create a new column or overwrite the original cells.

Add data labels step by step

These directions are for Google Sheets in a desktop web browser. First create a chart if you do not already have one: select the relevant cells and choose Insert > Chart. Sheets usually suggests a chart type, which you can change in the Setup tab of the chart editor.

Click the chart once to select it. If the chart editor does not open, click the three-dot menu on the chart and choose Edit chart. You can also double-click the chart.
In the chart editor sidebar, open the Customize tab.
Expand Series. If the chart contains multiple series, use the series selector to choose the series you want to change, or choose the option that applies the setting to all series.
Check Data labels. Labels should appear on the chart immediately. If they do not, check that the selected series contains plottable numeric values and that the chart type supports labels.
Use the options beneath Data labels to choose a label type, position, or appearance if those controls are available for the chart.

To remove the labels later, return to Customize > Series and clear Data labels. You can close the chart editor when finished; Sheets saves chart edits as you work.

Choose what the labels display

The best label depends on what readers need to learn from the chart. For a chart comparing quantities, the value is usually the most direct choice. For a pie chart that represents parts of a whole, a percentage may be more useful. A category label can help identify what a point or slice represents, although the chart may already show those names in its legend or along an axis.

Google Sheets offers different label choices for different chart types, so do not expect every option to appear in every chart. Some chart types expose a Label menu with choices such as Value, Percentage, or Category; other types offer fewer choices or use different wording. If you cannot find a particular option, check the chart type and the selected series before assuming the feature is broken.

Think about the meaning of the data as well as its format. A label showing 0.25 may be technically correct but less intuitive than 25% if the numbers represent proportions. Format the source cells appropriately when the chart should reflect units such as currency, percentages, or dates. The way chart labels display can depend on the source values and the chart’s available formatting controls.

For instance, a monthly table with months in column A and order counts in column B might produce a column chart. Value labels make the count for each month visible on its column. If the chart instead compares each month’s share of an annual total, a percentage label may make the comparison clearer, but only if the chart type and data setup support that interpretation.

Set label position and appearance

When Sheets provides position controls, use them to keep labels close to their data marks without obscuring important information. Options vary by chart, but may include placements inside or outside a bar, at a bar’s end, or near the center. A position that works for a tall column may cause labels to collide on short columns, so inspect the entire chart after changing it.

The chart editor may also offer controls for label text color, font, or size. Make labels readable at the size at which the chart will actually be viewed, including after it is inserted into a document or presented on a screen. Strong contrast matters: pale text against a light bar can be hard to read even when the label itself is large enough.

If labels overlap, try a different position, simplify the chart, or label fewer series. Making the chart much larger can help, but it does not solve every collision. A chart with dozens of closely spaced points may be clearer without labels, with a table alongside it, or with a separate chart focused on fewer categories.

Apply labels to one series or several

A series is a group of related values plotted together, often represented by one color. In a chart comparing revenue and expenses by quarter, revenue and expenses are separate series. In Customize > Series, select the relevant series before turning on Data labels if you want labels on only one group. This can keep a busy chart readable while still highlighting the most important measure.

For example, if a chart shows both actual results and a target, you might label the actual values and leave the target series unlabeled. The target can still appear in the chart and legend. If you want labels on every series, apply the setting to all series where the editor provides that choice, then review the chart for clutter and overlapping numbers.

If the expected series is not listed, check the chart’s Setup tab. The data range, X-axis, and series selections determine what Sheets is plotting. A wrongly selected range can cause a header to be treated as data or omit a column entirely. Correcting the source range is often better than trying to fix label behavior in the Customize tab.

Fix common data-label problems

If labels do not appear, work through a few checks rather than rebuilding the chart immediately:

Confirm that the chart is selected and that you are in Customize > Series, not the Setup tab.
Check that Data labels is enabled for the series you intend to label. A different series may be selected in the Series controls.
Look at the source range and confirm that the series contains values the chart can plot. Text, blank cells, or an incorrectly included header can affect what appears.
Try a chart type that supports the label you need. Label controls and choices vary by chart type.
Check for labels that are present but difficult to see because of their position, color, size, or overlap.

Another common issue is expecting a label to display custom wording from a separate cell range. Google Sheets’ built-in data-label controls are not a general-purpose way to attach any arbitrary text to every point. Depending on the chart, you may be able to show a category or value, but custom annotations can require a different chart setup or a separate text element. Keep the source table clear so readers can verify any customized presentation.

If labels appear to show the wrong values, inspect the chart’s data range and series before editing number formats. A chart may be plotting a different column than expected, especially if the selected data included multiple columns or rows. Also check whether the label option is showing a percentage or category rather than the raw value.

Data labels compared with legends and tables

Data labels are useful when readers need to see exact values at a glance, but they are not always the best way to explain a chart. A legend maps colors or symbols to series names; it does not ordinarily list the value of every point. Axis labels show categories or scale marks. A data table, by contrast, can show a larger set of exact figures in rows and columns, though it may take up more space.

Use labels when the chart has a manageable number of points and the values themselves are central to the message. Use a legend when several series need identification but individual numbers are secondary. For dense data, consider leaving labels off and providing a compact table or a note that explains the important values. These elements can work together, but repeating the same information in labels, a legend, and a nearby table may make the presentation unnecessarily busy.

Excel also supports chart data labels, but its chart editing interface and menu paths differ from Google Sheets. Instructions for Excel’s ribbon should not be followed as if they were Sheets steps; in Sheets, the relevant controls are in the chart editor under Customize > Series.

Keep labeled charts clear and trustworthy

Labels can make a chart easier to scan, but they can also imply more precision than the data supports. If values are estimates or rounded, format them consistently and avoid displaying extra decimal places that suggest false accuracy. For a chart of whole-number counts, showing several decimal places is usually distracting. For a rate where small differences matter, decimal places may be appropriate.

Use a consistent unit and explain it in the chart title, axis title, or a nearby note when it is not obvious. A label such as 120 is ambiguous if readers cannot tell whether it means dollars, people, or units sold. Likewise, percentages are useful only when the underlying calculation and chart make the denominator clear.

Before sharing or publishing the chart, check it at its final size and on the background where it will appear. Confirm that the labels do not obscure data, that colors are distinguishable, and that the source table supports the interpretation. A chart should remain understandable to someone who has not watched you build it.

Frequently Asked Questions

Can I add data labels to only one series in Google Sheets?

Yes. In the chart editor, open Customize > Series and select the series you want in the series selector, then enable Data labels. The available controls can vary with the chart type.

Can Google Sheets show percentages on a chart?

Some chart types, especially charts that represent parts of a whole, offer percentage labels. Select the chart and inspect the label choices under Customize > Series. Percentage labels are not available for every chart type.

Can I put labels inside or outside the bars?

Often, but the position choices depend on the chart type. After enabling Data labels, check the position control in the Series settings. If the option is absent, that chart may not support the placement you want.

Why are my chart labels overlapping?

There may be too many points for the available space, or the chosen position may crowd nearby labels. Try a different position, label fewer series, enlarge the chart, or use a table for exact values instead.

Do data labels change my spreadsheet cells?

No. They are part of the chart’s display settings, not edits to the source cells. When a plotted source value changes, a label based on that value can update along with the chart.

When labels help most

Data labels are most useful when a reader should be able to identify a few exact values without estimating from an axis. Start by turning them on for the series that matters, choose the clearest available label type, and check the result at its intended viewing size. If labels compete with one another or obscure the pattern, the chart may communicate better with fewer labels and a table or note for supporting detail.

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.