Scatter Plot Excel: How to Label Every Point With Names

How-to basics · Updated November 21, 2026

To label every point 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 the X Value and Y Value boxes if you want names only. This works in Excel for Microsoft 365 on Windows and makes each marker’s label come from its corresponding worksheet cell.

What point labels do in a scatter plot

A scatter plot places markers according to two numeric measures: one determines each point’s horizontal position (the X value), and the other determines its vertical position (the Y value). Unlike a line or column chart, a scatter plot does not normally use a text category for each point along an axis. As a result, a chart may show the relationship between two measurements clearly while leaving readers unsure what each dot represents.

Data labels supply that missing identity. They can show the X value, Y value, both values, or text drawn from cells, such as a product name, location, date, or sample ID. For example, a chart of advertising spend against sales might use the two measures for its axes and put a campaign name beside each marker. That makes an unusual point identifiable without asking readers to match it to a separate table.

Labels are most helpful when the chart has a manageable number of points or when the labels are short. If dozens or hundreds of points crowd together, labeling all of them can make the plot harder to read than the unlabeled version. In that case, label the important points or use an interactive chart or supporting table.

Prepare the worksheet data

Organize the data so that each plotted observation occupies one row. Keep the X values, Y values, and names aligned; the first name should describe the first X-Y pair, the second name the second pair, and so on. A simple arrangement could have campaign names in column A, advertising spend in column B, and sales in column C, with the observations starting in row 2.

  • Use one row per point and avoid sorting only one of the columns, which would separate names from their measurements.
  • Make sure the X and Y columns contain numeric values. Text such as “about 10” may not be plotted as a number.
  • Use short, distinct labels where possible. A compact product code may fit better than a long description.
  • Keep the label cells in a single range with the same number of rows as the points in the series.

To create the chart, select the X and Y data and choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select a scatter-chart subtype. If the chart already exists, confirm that its series uses the intended X and Y ranges: right-click the chart, choose Select Data, select the series, and choose Edit to inspect those ranges. The labels are an additional range; they do not change the coordinates that determine where markers appear.

Add labels from worksheet cells

In Excel for Microsoft 365 on Windows, click the chart and select the data series. If the chart has more than one series, make sure you select the series whose points you want to label; a label range applies to that series, not automatically to every series in the chart. Then follow these steps:

  1. Open Chart Design > Add Chart Element > Data Labels, and choose a position such as Right or Above. You can also right-click the selected series and choose Add Data Labels.
  2. With the labels selected, open Chart Design > Add Chart Element > Data Labels > More Data Label Options. This opens the Format Data Labels pane. If needed, right-click a label and choose Format Data Labels.
  3. In the pane’s Label Options, select Value From Cells. When Excel asks for a range, select the cells containing the point names and confirm.
  4. Clear Y Value and any other options you do not want displayed. Leave X Value selected only if you also want the horizontal coordinate printed next to each name.

For the example layout with names in A2:A11, X values in B2:B11, and Y values in C2:C11, select A2:A11 as the cell range for the labels. The range needs ten entries because the series has ten points. Excel matches the first selected label to the first point in the series, the second label to the second point, and continues in order. It does not infer the match from the text or search for a related X or Y value.

On Excel for Mac, use the chart’s data-label controls and the Format Data Labels pane to choose Value From Cells; ribbon placement can differ slightly from Windows. Excel for the web may not expose all the same custom-label controls. If you cannot find the cell-based option in the browser, open the workbook in the desktop Excel app, set the labels there, and then save the workbook.

Choose what each label displays

Cell-based labels are useful because the displayed text can be independent of the numeric data used to position the point. A point can sit at X = 12 and Y = 85 while showing “North region,” for example. In the Format Data Labels pane, combine Value From Cells with X Value or Y Value when context is useful, or leave the numeric options off for a clean name-only chart.

Consider what a reader needs to learn from the graphic before turning on several label options. Showing a name and both coordinates can be useful for a small technical plot, but it may produce clutter in a presentation. Labels can also be concise identifiers while a nearby table gives full descriptions. For dates, check that the source cells are formatted as dates and that the chart displays them in a readable form; if Excel shows an unexpected number or an overly long date, adjust the cell format or simplify the label text.

Labels can be ordinary typed text or the results of worksheet formulas. If a label cell contains a formula that produces a readable name, the chart can use the displayed cell result. That can make labels easier to maintain when names are assembled from other fields. Keep the label range aligned with the plotted observations even if the text is generated automatically.

Format and position the labels

Once labels are in place, use the label-position choices in the Format Data Labels pane to move them relative to their markers. Available positions depend on the chart type and may include options such as Above, Below, Left, Right, or Center. Try a position that avoids covering the point and nearby labels. There is no single best position for every plot because clusters and gaps vary across the chart.

You can change the label font, size, color, and number formatting using the formatting controls. Select all labels to apply a consistent style, or select an individual label to emphasize one observation. A subdued font color can keep labels from overpowering the data; a high-contrast color can help when the plot has a dark background. Avoid reducing the font so much that the labels become unreadable at the size where the chart will actually be viewed.

Excel may place labels close together when points are clustered. You can drag a label to a clearer position, but manual placements may need attention if the data or chart dimensions later change. For a chart that will be updated repeatedly, prefer concise labels and a layout with enough space rather than relying on extensive manual repositioning.

Label only selected points

Sometimes the goal is not to name every marker. You might want to call out the maximum, minimum, target, or an outlier while keeping the rest of the plot uncluttered. One approach is to add labels for the whole series and remove the labels you do not need: select an unwanted label and press Delete. Take care to select the label, not the marker or the entire series.

For a more controlled method, click the series once, then click the specific marker again so that only that point is selected. Right-click the selected point and choose Add Data Label. Repeat for other points that need annotation. Depending on how the chart is selected, Excel may first select the full series, so check that only one marker has selection handles before adding a point-specific label.

For charts that update often, a helper series can be more maintainable than manually labeling and deleting individual points. A helper series can include coordinates only for the observations to call out, with the other rows left out of that plotted series, and then use cell-based labels for those selected observations. This takes more setup, but it keeps annotations tied to the data and avoids displaying a label beside every marker.

Common problems and how to fix them

  • The labels show numbers instead of names: In Format Data Labels, select Value From Cells and choose the text range. Then clear X Value or Y Value if those numbers should not appear.
  • Names are attached to the wrong points: Compare the order of the label cells with the order of the X-Y pairs in that series. Sort or filter the source data as a complete table, not as isolated columns.
  • Some labels are missing: Check that the selected range covers the series’ points and that the corresponding cells are not empty. Confirm that you selected the intended series, particularly when the chart contains multiple groups.
  • The labels overlap: Shorten the text, change the label position, enlarge the chart, or show labels only for key observations. Displaying names and coordinates together adds more text and can make overlap worse.
  • The option is unavailable: Make sure a chart data label or series is selected and that you are using the desktop app if the browser interface does not offer the cell-based setting.

A frequent misconception is that an X-Y scatter chart has a built-in category label column that automatically follows each point. The chart’s X and Y values define position; names are a separate labeling choice. Similarly, changing a cell’s displayed label does not move a point unless the X or Y source value changes.

When to use another labeling method

Cell-based data labels are usually the best choice when each point needs a short, data-linked name. For a small number of one-off annotations, a text box can be quicker, but it may not stay with the intended observation if the chart is resized or the data changes. A separate data table can be better when readers need many details that would overwhelm the plot itself.

If a dense chart needs only a few identified observations, consider labeling those points rather than all of them. Another option is to divide the data into multiple series when different groups need distinct visual treatment. That can clarify group membership, but it does not eliminate the need for point names if readers must identify individual observations. Choose the method that preserves the chart’s main message instead of treating every available label as essential.

Frequently Asked Questions

Can Excel label every point in a scatter plot with a different name?
Yes. Use Value From Cells in the Format Data Labels pane and select a label range with one matching entry for each point in the selected series.

How do I show only names and not X and Y values?
After choosing the cell range, clear the X Value and Y Value options under Label Options. The cell-based text remains as the label.

Can I label just one point in Excel?
Yes. Select the series, select the individual marker a second time, then right-click it and choose Add Data Label. You can also remove unwanted labels after adding labels to the series.

Do scatter plot labels update when worksheet names change?
Cell-based labels reflect the contents of their source cells. If a name changes in the selected label range, the chart label can update with it; the X-Y coordinates remain controlled by their own source ranges.

Why do my scatter plot labels appear in the wrong order?
Excel associates the selected label cells with points by their order in the series. Make sure the label range follows the same row order as the corresponding X and Y values.

Related

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.