Excel Scatter Plot With Named Points: Add Name Labels

To show names beside points in an Excel scatter plot, put the names in worksheet cells, select the chart, and use Chart Elements (+) > Data Labels > More Options. In the Format Data Labels pane, choose Value From Cells, select the name cells, and clear the X or Y value options if you want names only.

What named points mean 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. Excel does not normally use a row’s text name as the point label automatically. A chart might show a dot at (12, 38), for example, without identifying it as “North Branch.” Adding labels from cells connects each plotted point to a readable name.

This is useful when the identity of individual observations matters more than the number of points. A team might plot branches by monthly sales and customer satisfaction, label each dot with the branch name, and quickly spot which locations are high in both measures. For a chart with hundreds of observations, labels can overlap; naming every point is not always the clearest choice.

Set up the worksheet data

Keep each observation on one row, with a label column and two numeric columns. For example, use columns A, B, and C for Branch, Sales, and Satisfaction:

North: sales 12, satisfaction 38
Central: sales 19, satisfaction 31
South: sales 15, satisfaction 44

The names should line up row by row with their X and Y values. Avoid blank rows inside the data, and check that the two plotted columns contain numbers rather than text that only looks numeric. The names can be words, short codes, or a combination such as “North (12).” Keep them concise so they remain readable beside the markers.

If the sheet has several data series, decide which label column belongs to each series before building the chart. Each series can use its own matching set of names. A single label range should have the same number of entries as the points in the series, in the same order.

Create the scatter chart

Select the two numeric columns, including their headers, and choose Insert > Insert Scatter (X, Y) or Bubble Chart. For a basic chart, select the first Scatter option, which shows markers without connecting lines. Excel uses the first numeric column as X values and the second as Y values. If names sit between or outside those columns, Excel may not include them as the plotted values; that is fine because you will select the names separately for labels.

Check the axes before adding labels. If the horizontal and vertical values are reversed, right-click the chart and choose Select Data. Select the series and choose Edit to confirm the X values and Y values point to the intended worksheet ranges. A scatter chart is different from a line chart: its horizontal axis is numeric, not a list of equally spaced categories.

Add names from cells

Select the chart, then click the Chart Elements (+) button beside it.
Check Data Labels. Use the arrow beside the option to choose a starting position such as Right or Above. The exact position can be changed later.
Click the arrow beside Data Labels and choose More Options to open the Format Data Labels pane. You can also right-click a label and choose Format Data Labels.
Under Label Options, select Value From Cells. In the range box, select the worksheet cells containing the names for the plotted points, then confirm.
Clear X Value and Y Value if you want each point to show only its name. Leave either value selected if the reader needs the coordinates as well.

Excel may initially show the Y values when you turn on data labels. That is expected: those are the default labels, not a sign that the chart is wrong. Choosing Value From Cells adds the label range; clearing the numeric options removes the unwanted values. If you accidentally select the wrong cells, return to Value From Cells and select the correct range.

Choose what each label communicates

Names alone are compact, but sometimes a chart needs more context. You can keep the name and also display X or Y values, or create a helper column that combines a name with a useful detail, then use that column as the label range. For instance, a helper label such as “North — 12” could identify the branch and show its sales figure. This is often easier to scan than displaying several default fields separately.

Think about the chart’s purpose before adding every available value. If the axes are clearly titled and readers can estimate positions, names alone may be enough. If exact coordinates matter, show values or include them in the label. Long text can cover nearby dots, so shorten labels, enlarge the chart, or label only the most important observations.

Format labels and keep the chart readable

Use the Format Data Labels pane to adjust label position and other label options. The choices available depend on the chart and Excel version, but common positions include above, below, left, and right. If labels collide, try different positions for nearby points, increase the plot area, or reduce the font size modestly. A larger chart can help more than very small text.

Scatter plots often benefit from restrained formatting. Use a clear axis title for each measure, a marker size that makes points visible without hiding labels, and a color that contrasts with the chart background. If the names are the main information, avoid a legend that repeats the same names. A legend identifies series; it does not identify each individual point.

For a dense chart, label a selected subset instead of every observation. One approach is to create a separate series containing only the points you want to call out, then apply labels to that series. This keeps the full data pattern visible while directing attention to a few important cases.

Use names with multiple series

A chart can contain several scatter series, such as one series for each product category. Select the series whose labels you want to change before opening the Format Data Labels pane. Then choose the matching name range for that series. Repeat for each series that needs point names. Selecting the wrong series can make Excel attach labels to the wrong set of markers, even if the label range itself is correct.

When series are added or reordered, check their label ranges again. The labels are associated with points in order, not matched by searching for a name or comparing coordinates. If the first name cell belongs to the second plotted point, the chart will display the wrong name at that point. Keep each series’ X values, Y values, and label cells aligned row by row.

Common problems and fixes

“Value From Cells” is missing: Confirm that you selected data labels, not the chart area, an axis, or the series itself. Open the Format Data Labels pane for the selected labels. Excel for the web may have fewer chart-editing options than the desktop app; if the command is unavailable, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Names appear in the wrong places: Compare the label range’s order with the series’ X and Y ranges. Sort or filter the source data before charting only if all associated columns stay together. A mismatch in row order is a common cause.
Numbers still appear beside names: In Label Options, clear X Value and Y Value, and clear any other value choices you do not want. Excel can show a name and coordinates at the same time.
Labels overlap: Use shorter labels, move individual labels, enlarge the chart, or label only key points. Avoid shrinking text until it is difficult to read.
New rows are not labeled: Check whether the chart series and the Value From Cells range include the new rows. Extending one range does not always extend the other, particularly when the chart uses fixed cell references.

Also check whether a blank cell is being used as a label. Blank labels can leave an unlabeled dot, while a formula that returns an empty string may behave differently depending on the chart setup. If a point must be identifiable, use a nonblank label and verify the result after changing the source data.

Manual labels and other approaches

For just one or two points, you can select a data label and replace its displayed text manually. This is quick for a presentation chart that will not change, but it is less dependable for a chart that updates: edited data or a changed point order can leave the text attached to the wrong observation. Labels linked to worksheet cells are usually the better choice for a maintained report.

Text boxes can also annotate a chart, particularly for explanations such as “new location” or “seasonal outlier.” They are not a substitute for point labels when the chart changes, because you must reposition them yourself. A table beside the chart may be clearer when there are many points or when readers need full details that would make the plot crowded.

Frequently Asked Questions

Can I use text instead of numbers as the X-axis in a scatter plot?
A scatter chart requires numeric X and Y values. If the horizontal values are categories such as product names, use a line chart with a category axis or another chart type designed for categories. You can still use text to label points on a scatter chart.

Can Excel automatically show the names in a column?
Yes. Use Data Labels and select Value From Cells in the Format Data Labels pane, then choose the cells containing the names. Excel uses the selected cells as labels for the points in that series.

Will point names update when I edit the worksheet?
Labels linked through Value From Cells generally reflect edits to those cells. Make sure the label range still covers the same points if you add observations or change the chart’s series ranges.

Can I show a name and the exact X and Y coordinates?
Yes. Keep Value From Cells selected and also select X Value and/or Y Value in Label Options. The resulting labels can be longer, so check that they do not overlap.

Why does my scatter chart show the wrong name beside a point?
The label range is matched to plotted points by position in the series. Check that each name is on the same row and in the same order as its X and Y values, and confirm that you edited the intended series.

Windows and Mac notes

These directions are for Excel for Microsoft 365 on Windows. Excel for Microsoft 365 on Mac has the same core approach, although chart controls and the formatting pane may appear in different places. Use the chart’s data-label controls and look for Value From Cells in the label options. In Excel for the web, chart editing capabilities can differ, so use the desktop app if you cannot find that setting.

Once the labels are connected to the right cells, the chart becomes easier to interpret without sacrificing the numeric meaning of a scatter plot. The key is keeping the name range in the same order as the X and Y data, then choosing only the label details that help readers understand the points.

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.