Google Sheets Chart Annotations: Labels, Notes, and Tips

Yes—you can annotate a chart in Google Sheets by turning on data labels, adding a chart title or subtitle, or placing a text box or drawing near a specific point. Sheets does not provide a general-purpose, point-by-point annotation column like the Google Charts API, so the best method depends on whether you need labels tied to data or a one-off callout.

What “annotation” means in Google Sheets

People use “chart annotation” to mean several different things: showing the values on bars or points, naming categories, marking an unusual event, or adding an explanatory note beside a particular feature. Google Sheets handles some of these directly in the chart editor and others with objects placed on the sheet.

This distinction matters because a value label is connected to a plotted data point, while a text box is simply positioned visually. A label can move with the point as the data changes; a manually positioned callout may not stay aligned if the chart is resized, the data changes, or the chart layout shifts.

There is also a separate Google Charts feature called an annotation role. It is available when building charts with the Google Charts API, but it is not a general annotation-column setting in the standard Google Sheets chart editor. In Sheets, use the built-in label settings for supported labels, and use a drawing or text box for a custom explanation.

Show values or categories with data labels

For the most reliable annotation that follows the chart’s data, use data labels. They are useful when readers need exact values without estimating from an axis. For example, a column chart showing quarterly orders can display the value above each column, while a pie chart can show each slice’s value or category.

Click the chart, then open its three-dot menu and choose Edit chart. You can also double-click the chart.
In the Chart editor, open Customize.
For most supported chart types, expand Series and turn on Data labels.
If the chart has multiple series, select the series you want to format where that option is available.
Choose an available label type and adjust the label position, font, or number format if those controls are offered for that chart.

The available controls depend on the chart type. For a pie chart, look under Customize > Pie chart for Slice label rather than expecting the same Series controls used by a column or line chart. A chart may also become crowded if every point has a label; consider labeling only a small chart, a short series, or values that are central to the message.

Data labels generally display information associated with the plotted series, such as a value, category, or series name where the chart type supports it. They are not a universal way to enter a different sentence for each point. If you need labels such as “product launch” or “price change,” use a separate callout method or change the chart design to make the event clear.

Add a custom note beside a chart point

For a one-off explanation, such as noting that a supplier outage caused a sudden dip, add a drawing or text box on the sheet. Choose Insert > Drawing, create a text box, add the note, and save and close the drawing. Position it near the chart point or area it explains. You can also use shapes and connector lines in the drawing to make the relationship more obvious.

This is a visual overlay, not a data-linked annotation. If the chart is moved or resized, check the callout’s position afterward. A drawing placed on the sheet can also be awkward when viewers use different screen sizes or print settings. Keep the note short, and avoid covering axes, data labels, or other points. For a report that will be updated often, a short subtitle or a clearly labeled note next to the chart may be more maintainable than a callout pinned over a particular mark.

To explain the whole chart rather than one point, use the chart title or subtitle. Select the chart, open Edit chart, then go to Customize > Chart & axis titles. Select the title type and enter the wording. A title such as “Orders fell during the February system outage” gives useful context, but it does not identify an exact data point; pair it with a visual callout if that precision matters.

Choose an annotation method for the job

Before adding notes, decide what question the annotation should answer. A chart often needs only one kind of explanation. Adding labels, arrows, a long subtitle, and a separate note all at once can compete with the data rather than clarify it.

Need exact plotted values? Turn on data labels for the relevant series or use the pie-chart slice-label setting.
Need to identify a category? Use the chart’s category labels or a supported category label option, and make sure the source data has clear names.
Need to explain a specific event? Add a concise drawing or text callout near the point, then recheck its placement after editing the chart.
Need to explain the overall takeaway? Use a descriptive chart title or subtitle.
Need to record details for collaborators without putting them on the chart? Add explanatory text in adjacent cells or use a cell note. Those notes are useful in the sheet, but they do not appear as chart annotations.

For example, a monthly revenue line chart could use a callout reading “Store closed for renovation” beside the month with a temporary drop, while the subtitle states the date range. If readers also need the exact revenue for every month, turn on data labels only if they remain legible. Otherwise, leave the values on the vertical axis and label just the point that needs explanation with a separate drawing.

Make annotations readable and useful

Annotations should add information that is not already obvious from the chart. Prefer a short phrase with a concrete meaning over a vague label such as “change” or “important.” If a note contains a cause, make sure the source data or reporting process supports that cause; the chart itself cannot establish why a value changed.

Use a consistent visual style. A restrained color can distinguish the callout from the data, but color should not be the only cue—include readable text, and use a line or shape when necessary. Check contrast against the chart background and avoid tiny type. If several points need explanations, use concise numbered markers with a nearby key or a small table instead of covering the plot with paragraphs.

Also check the chart at its intended size. Labels that look clear while editing may overlap when the chart is embedded in a document or viewed on a smaller screen. If labels collide, try reducing the number shown, changing their position if the editor allows it, widening the chart, or simplifying the series. Rotating labels or shrinking the font too far can make a chart technically labeled but difficult to read.

Keep annotations accurate as data changes

Built-in data labels are usually the better choice for recurring reports because they are generated from the chart’s data. A manually added drawing is not linked to a particular cell or point, so it can become misleading after the data range changes. For example, if a new month is inserted before the month marked by a callout, the marker may visually point to the wrong month even though the text has not changed.

When a chart is refreshed, verify all manually added callouts, titles, and notes. Check that each one still refers to the intended category and that the chart’s source range includes any new rows or columns. If you maintain the chart as a template, leave a reminder near it to review the drawing when the underlying data is updated. Keep the underlying explanation in a cell or separate notes table as well if it must be preserved independently of the visual placement.

For collaborative sheets, use clear wording and avoid relying on a reader to infer what an arrow means. A callout should name the event or value it refers to, and the arrow should point unambiguously. Cell notes and comments can support collaboration, but they are not substitutes for a visible chart label when the chart is shared or exported on its own.

Google Sheets annotations compared with other tools

Google Sheets is suitable for straightforward chart labels and simple visual callouts. Its chart editor provides chart-specific controls, while drawings offer a flexible way to explain a particular area. The trade-off is that a drawing’s position is manually maintained, and the editor does not offer the same general data-driven annotation workflow as the Google Charts API.

If you need annotations that are generated automatically from a separate text field for many points, consider whether a different charting workflow is more appropriate. The Google Charts API supports annotation roles for charts built in code. Other reporting or visualization tools may also offer richer interactive annotations. Those options involve a different setup; they are not settings that can be enabled inside an ordinary Sheets chart.

For a small number of explanations, a Sheets drawing is often simpler than rebuilding the chart elsewhere. For a frequently refreshed dashboard with many event markers, a manually placed drawing can become a maintenance burden. In that case, compare the time spent checking callouts with the effort of moving the visualization to a tool that supports the annotation behavior you need.

Frequently Asked Questions

Can I add a text annotation to one point in a Google Sheets chart?
Not as a general text field tied directly to an individual point in the standard chart editor. You can turn on supported data labels or place a drawing or text box near the point. The drawing is positioned manually and should be checked when the chart changes.

How do I show numbers on a Google Sheets chart?
Select the chart, choose Edit chart, open Customize > Series, and turn on Data labels for a supported chart type. For pie charts, use Customize > Pie chart > Slice label. The exact options depend on the chart type.

Can Google Sheets use a column of custom annotation text?
The standard chart editor does not provide a universal annotation-column feature that turns arbitrary text in a source column into per-point callouts. A separate text box or drawing is a practical manual workaround; the Google Charts API has a distinct annotation role for charts built with that API.

Will a text box move with the chart point when the data changes?
No. A manually positioned drawing is not linked to a particular data point, so its placement can become inaccurate when the chart or its data changes. Recheck it after updates, or use built-in data labels for information that the chart can display automatically.

Can I add notes to a chart without showing them on the graph?
Yes. Put explanatory text in cells beside the chart or add a note to a relevant cell. These can help people working in the spreadsheet, but they will not appear as visible annotations on the chart itself.

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.