Chart Labels in Google Sheets: Add, Edit, and Format

To add chart labels in Google Sheets, open the chart, choose Customize in the Chart editor, then use Chart & axis titles for titles or Series and Data labels for values shown on data points. Category labels and legend names usually come from the cells used to build the chart, so changing those source cells can change the displayed text.

What chart labels mean in Google Sheets

Chart labels are the pieces of text that help readers identify what a chart shows. The term can refer to several different things, and choosing the right control depends on which text you want to change. A chart title describes the entire graphic, while axis titles explain what the horizontal or vertical scale measures. Category labels identify items along an axis, such as months or product names. Data labels display information directly beside or inside individual bars, points, or slices. A legend identifies the series represented by colors or line styles.

These elements are related, but they are not interchangeable. For example, a bar chart might have a title of Monthly orders, category labels for January through June, a vertical axis title of Orders, data labels showing each month’s total, and a legend distinguishing online from in-store orders. Turning on data labels will not add an axis title, and changing a legend name will not rename a category.

Google Sheets charts are generally connected to the spreadsheet range that supplies their data. As a result, some visible labels are controlled in the chart editor while others are drawn from the source cells. Knowing that distinction is the quickest way to avoid editing the wrong setting.

Add a chart title or axis title

In Google Sheets in a web browser, double-click the chart to open the Chart editor. Select Customize, expand Chart & axis titles, and choose the kind of title you want from the title-type menu. Depending on the chart, the choices can include chart title, chart subtitle, horizontal axis title, and vertical axis title. Enter the wording in the title text field.

Click the chart once, then double-click it to open the Chart editor.
Choose Customize and open Chart & axis titles.
Select the title type, such as Chart title or Vertical axis title.
Type the title in the text field, then adjust its appearance if needed.

A useful chart title says what the reader is looking at, not merely the chart form. For example, Orders by month is more informative than Bar chart. Axis titles should clarify units or meaning when the labels alone are not enough: Revenue (USD) is clearer than Revenue if a reader might mistake dollars for thousands of dollars. Avoid repeating information that is already obvious from the chart and its surrounding text.

Title text is set in the chart editor, not by renaming the chart’s source range. In contrast, if you want to change category names or the series name in the legend, edit the corresponding cells or the chart’s selected data range.

Show values on bars, lines, and points

Data labels place values or other available information next to chart marks. To display them, open the chart editor, go to Customize, expand Series, and enable Data labels. If the chart has more than one series, use the series selector in that section to choose which series to format. The available label choices and positions depend on the chart type; where offered, the label setting may let you show a value, category, or series name.

For instance, imagine a column chart with monthly order totals of 120, 145, and 131. Data labels can put those numbers over the columns so readers do not have to estimate them against the vertical axis. This is especially helpful when there are only a few bars or when a chart will be read at small size. It can become distracting on a chart with dozens of points, where the labels may overlap or obscure the data.

Some chart types provide their own label controls. For a pie chart, open Customize and expand Pie chart, then choose a setting under Slice label. Depending on the chart, choices can include a category label, value, percentage, or a combination. Percentages are useful for showing each slice’s share of the whole, but they can be misleading if the plotted values do not represent parts of one meaningful total.

Use the chart editor’s label options rather than typing numbers onto the chart as separate text boxes. Data labels remain associated with the plotted data when values change. If you need to display a particular kind of label that the chart type does not offer, consider whether a different chart type or clearer source categories would communicate the information better.

Change category labels and legend names

Category labels usually come from a column or row in the chart’s data range. In a chart of monthly totals, the cells containing January, February, and March may supply the horizontal-axis labels. To change what readers see, edit those cells or adjust the range and label settings under Setup in the Chart editor. The X-axis field identifies the range used for horizontal categories in many chart types.

Series names generally come from header cells. If a chart compares Online and In store orders, those words may be the headers above the two number columns and may also appear in the legend. Check Setup and the options for using the first row or column as headers or labels if the chart has treated a header as data, or data as a header. The exact setup depends on whether the data is arranged in rows or columns.

A legend is a key to the chart’s series, not a list of every individual category. In Customize, open Legend to change its position and available text styling. If a legend entry has the wrong name, changing the series header is usually the right fix; hiding the legend only removes the key and does not rename the series.

Format labels for readability

After adding a title or data labels, use the formatting controls in the relevant section of Customize. Depending on the selected chart and element, you may be able to change font, text size, color, or title formatting. Axis sections also offer controls for how the axis is displayed. Options differ by chart type, so a setting shown for a column chart may not appear for a pie chart.

Good formatting makes labels easy to scan without competing with the data. A practical approach is to keep titles concise, use a readable text size, and reserve strong colors for information that needs emphasis. Check the chart at the size at which people will actually view it. Labels that fit on a large screen can collide when the chart is embedded in a document or viewed on a phone.

Number formatting matters too. If a label shows an awkward value such as 0.25 when the intended meaning is 25%, check the value and number format in the source cells and the chart’s available formatting options. Do not simply append a percent sign to a decimal unless the underlying data is expressed as a percentage: a value of 25 formatted as a percentage would represent 2,500%, not 25%. For currency, make the unit clear in the axis title or chart context, and use consistent precision across the series.

Not every long category name needs to be shortened. You can make the source labels more concise, widen the chart, or choose a chart layout that gives the labels more room. If abbreviated labels are necessary, explain the abbreviations in a note or nearby text so the chart remains understandable.

Choose which labels to show

The most useful label setup depends on the chart’s purpose and the number of values. A chart designed to show an overall trend often needs a clear title, an appropriate axis, and limited point labels. A chart intended for exact lookup may benefit from data labels, especially when it contains only a small number of values. A chart comparing multiple series needs a readable legend or direct labels that make the series identity clear.

Use axis titles when units or measurements are not self-evident, such as Temperature (°C) or Cost per unit.
Use category labels to identify dates, products, locations, or other groups along an axis.
Use data labels when exact values matter more than a clean, uncluttered view.
Use a legend when color or line style distinguishes multiple series and the series names are short.
Use pie-slice labels sparingly and only when each slice is part of a meaningful whole.

One common misconception is that every chart should show every number. A chart with a dense set of labels can be harder to read than one with a well-scaled axis and a small amount of supporting text. If the reader needs exact values for many points, a table alongside the chart may be clearer than forcing all values into the graphic.

Fix common chart-label problems

If labels are missing, first identify what kind they are. For missing values on the bars or points, check Customize > Series and the data-label setting. For missing categories or a blank legend entry, inspect the selected range and the header or label options in Setup. A chart may be plotting the wrong cells even when its appearance seems mostly correct.

If category names appear as bars or points rather than along the axis, the chart may have interpreted the rows and columns in the wrong direction. In Setup, review the data range and whether rows or columns are being used as series. The option to switch rows and columns can help when the same data has been arranged differently than the chart expects. Verify the result against the sheet instead of relying on the preview alone.

Overlapping labels are usually a space or density problem, not a broken chart. Try widening the chart, reducing the number of displayed data labels, shortening category names, or choosing a chart type that suits the data. Rotating or shrinking text may help in some cases, but very small labels are not a useful solution if readers cannot read them.

If edited source text does not appear in the chart, confirm that the cells you changed are inside the chart’s data range and that they are serving as labels or headers. If the chart title does not update when a cell changes, that is expected for a title entered directly in the chart editor; title text is a chart setting. Keep the title concise and update it directly when the subject changes.

How Google Sheets compares with Excel

Google Sheets and Microsoft Excel both support chart titles, axis titles, legends, and data labels, but their interfaces are different. The steps in this guide use Google Sheets in a web browser: double-click the chart, then work in the Chart editor’s Setup and Customize tabs. Excel for Microsoft 365 on Windows uses chart-specific ribbon controls, including Chart Design and Format; its exact controls and label choices can vary by chart type. Instructions for one program should not be assumed to match the other.

The underlying idea is similar in both programs: some text comes from cells, and some is a chart-level setting. If a workbook or spreadsheet is shared between applications, review the chart after opening it in the other program. Formatting and chart features do not always transfer identically, so verify that titles, series names, and data labels still communicate the intended meaning.

Frequently Asked Questions

How do I add data labels in Google Sheets?
Double-click the chart, choose Customize, open Series, and enable Data labels. If there are multiple series, select the one you want to label.

How do I change the labels on the horizontal axis?
Edit the cells used for the chart’s categories, or change the category range under Setup in the Chart editor. Check that the chart is using the intended row or column as labels.

Can I put percentages on a Google Sheets pie chart?
Yes. Open Customize > Pie chart and choose a percentage option under Slice label, when available for that chart. Confirm that the slices represent parts of a meaningful whole.

Why are my chart labels overlapping?
There may be too many labels for the chart’s available space. Make the chart larger, shorten category text, or show fewer data labels. If exact values for many points are essential, consider adding a table rather than crowding the chart.

Can a chart title automatically use text from a cell?
The chart title is entered as chart text in the Chart editor, while category labels and series names typically come from the source range. If the wording in a title cell changes, update the chart title in the editor as well.

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.