Excel Scatter Plot Labels: Add Names to Points

To label points in an Excel scatter plot with names, select the chart, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options, then select Value From Cells and choose the cells containing the names. Clear options such as Y Value if you want names alone. This links each point to a worksheet cell, so labels can update when those cells change.

Why label points in a scatter plot?

A scatter plot places each observation according to two numeric values: one determines its horizontal position and the other its vertical position. By default, Excel usually shows the values or no identifying text, depending on the chart and its settings. A label can make an unusual observation, a named product, or a particular person’s result identifiable without making the reader look up a separate table.

Labels are most useful when you have a modest number of points or want to call attention to selected observations. If a chart has hundreds of points, showing every name can turn it into a wall of text. In that case, consider labeling only key points, splitting the data into smaller charts, or using a companion table to identify observations.

For example, a chart comparing advertising spend with sales might plot each campaign’s spend on the x-axis and sales on the y-axis. Labels such as “Spring launch” and “Email promotion” tell the reader which campaign each dot represents. The labels do not change the positions of the points; they add context to the chart.

Prepare the worksheet data

Keep the point names, x-values, and y-values in separate columns, with one observation per row. For instance, put campaign names in column A, advertising spend in column B, and sales in column C. Use a header row, and make sure each name and pair of values stays together on the same row. The name range must have the same number of data rows as the plotted series.

To create the chart, select the two numeric columns, including their headers, and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Excel uses the first selected numeric column for x-values and the second for y-values. If you select the name column as well, Excel may interpret it in an unintended way, so it is often simplest to build the chart from the numeric columns first and then connect the names through data labels.

Use actual numbers for both axes, rather than numbers stored as text.
Avoid blank rows inside the data range; blanks can create missing points or complicate the series.
Check that the plotted series has the expected number of points before assigning labels.

Add labels from worksheet cells

In Excel for Microsoft 365 on Windows, click the chart and then click a point in the series so the series is selected. Choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. This opens the Format Data Labels pane. If the chart has no labels yet, you can also use the chart’s plus button, select Data Labels, and then open More Options or the formatting pane.

In the Format Data Labels pane, open Label Options and select Value From Cells.
When the data-label range dialog appears, select the worksheet cells containing the point names, excluding the header. For example, select A2:A11 for ten points.
Confirm the range. In Label Options, clear Y Value, X Value, or other value options if you want the name to be the only label.
Choose a label position, such as Above or Right, if the default placement is hard to read.

Excel matches the selected label cells to the points in the series by their order. The first label cell applies to the first point, the second to the second, and so on. If the names appear beside the wrong dots, check the series’ x- and y-value ranges and the order of the label range. A mismatch in row order is a common cause of incorrect labels.

Once the labels are connected to cells, editing a name in the worksheet updates the corresponding chart label. This is usually preferable to typing labels one at a time: it keeps chart text connected to the source data and makes corrections easier.

Choose names, values, or both

Excel can display several kinds of label information, and the best choice depends on what the chart is meant to communicate. Value From Cells is the option for names or custom text. X Value and Y Value show the coordinates of a point, while Series Name identifies the plotted series. You can combine a name with one or both numeric values when readers need both identity and measurement.

For example, a chart of ten products could show just product names if a separate table contains the exact figures. If the chart is intended to communicate precise measurements, a label might include the product name and its y-value. Avoid showing every available field by default: long labels with several numbers can overlap and distract from the pattern.

Labels are not the same as axis titles or a chart legend. Axis titles explain what the horizontal and vertical scales measure; a legend distinguishes multiple series; data labels identify individual points or show their values. A chart can use all three, but each should have a distinct purpose.

Create custom text for each point

If a name alone is not informative enough, create a helper column that combines a name with values or a short category. Then use that helper column as the Value From Cells range. Keep the result concise: detailed notes belong in a table or annotation rather than in every chart label.

With names in A2:A10, x-values in B2:B10, and y-values in C2:C10, enter this formula in D2 and fill it down to D10 to make a label from the name and both coordinates:

=A2&" ("&TEXT(B2,"0.0")&", "&TEXT(C2,"0.0")&")"

If A2 contains North, B2 contains 12.5, and C2 contains 8, the result is North (12.5, 8.0). The TEXT function controls how the numbers appear in the label; change the format codes if you want whole numbers, percentages, or a different number of decimal places. The underlying chart coordinates remain numeric even though the helper column produces text.

For short labels, you can also type text directly into cells without using a formula. A helper column is useful when many labels need a consistent format or when the label should change automatically as source values change. After changing the helper text or formula, check that the label range still covers all plotted observations.

Format labels and reduce clutter

After adding labels, use the Format Data Labels pane to adjust their placement and appearance. Excel offers positions such as Center, Left, Right, Above, and Below, although available choices can depend on the chart type. You can also select the labels and use the ribbon’s font controls to change text size, color, or emphasis. Keep the formatting consistent so that labels do not compete with the data.

When labels overlap, first try a different position or reduce the font size slightly. You can also enlarge the chart, shorten the label text, or label only the points that matter most. If two points are close together, moving one label may help. Click a label once to select the series’ labels, then click it again to select an individual label and reposition it. Be careful not to drag a data point by mistake.

Excel does not automatically arrange every label to avoid overlap in a dense scatter plot. A label position that looks clear on one chart may collide after the chart is resized or the data changes. Review the chart at the size at which it will be viewed or printed, and recheck labels after changing the data, axis scale, or chart dimensions.

Label multiple series correctly

A scatter plot can contain multiple series, such as results for different regions or product groups. Each series has its own x-values, y-values, and point order. To label points from cells, select the intended series before opening the data-label options, then assign the matching label range for that series. Repeat the process for each series that needs point labels.

Use a separate label range for each series if the names differ. If the same text would be repeated for every point, consider whether the legend already identifies the series and reserve point labels for the observations that need individual identification. Distinguish series with clear colors or marker shapes as well as labels; color alone may be difficult for some readers to distinguish.

Before assigning labels, check the series setup. Select the chart and use Chart Design > Select Data to review the series and its ranges. The order of the x-values, y-values, and labels should correspond within each series. Sorting one column independently of the others can break those relationships and cause labels to identify the wrong observations.

Common label problems and fixes

Value From Cells is missing: Confirm that you are formatting data labels for a selected series, not the chart title, axis, or plot area. Use the desktop version of Excel if the feature is unavailable in your current app.
Labels show numbers instead of names: In Label Options, select Value From Cells and choose the name range. Clear X Value and Y Value if those numbers should not appear.
Labels are assigned to the wrong points: Compare the label range’s row order with the series’ x- and y-value order. Correct the source rows or series ranges together rather than sorting just one column.
Some labels are blank: Check for empty cells, formulas that return an empty string, or a label range that is shorter than the plotted series.
Labels overlap or are cut off: Shorten the text, change label positions, enlarge the chart, or show fewer labels. Also check whether labels extend beyond the chart area.

One important distinction: filtering or hiding worksheet rows can affect which points appear, depending on the chart’s settings, but it does not make an incorrectly ordered label range correct. Keep each observation’s name and coordinates in the same row, and confirm the chart’s displayed points after filtering or changing source data.

Excel desktop, Mac, and web differences

The steps above describe Excel for Microsoft 365 on Windows. In recent desktop versions of Excel for Mac, the chart design and formatting controls are similar, though the ribbon and pane layout can differ slightly. Look for Chart Design, Data Labels, and Value From Cells in the selected chart’s formatting options. If you cannot find a control, make sure the chart is selected and that you have selected its data series or labels.

Excel for the web has fewer chart-editing controls than the desktop app, and the exact options available can depend on the current web version. If Value From Cells is not offered, open the workbook in the desktop Excel app to connect labels to a cell range. Avoid replacing linked labels with individually typed text unless the chart is small and you do not need the labels to update with the worksheet.

Frequently Asked Questions

Can I label each point in an Excel scatter plot with a name?
Yes. Add data labels, select Value From Cells in the Format Data Labels pane, and choose the cells containing the names. Make sure the names are in the same order as the plotted points.

How do I show only the point name, not its x- and y-values?
Use Value From Cells for the name range, then clear X Value and Y Value under Label Options. The exact options shown depend on the chart and selected series.

Can Excel scatter plot labels update when I change the worksheet?
Yes. Labels linked through Value From Cells update when the referenced text changes. Labels generated by a helper-column formula also update when that formula’s inputs change.

Why do my scatter plot labels appear beside the wrong points?
The label cells are matched to points by position in the series, not by searching for a matching name. Check that the label, x-value, and y-value ranges contain corresponding rows in the same order.

Can I label only selected points?
Yes. One straightforward method is to use a helper range that contains text for points you want labeled and blank results for the others, then use that range for Value From Cells. Check the chart afterward, because blank labels and chart behavior can vary with the data and Excel version.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.