Excel Chart: Add a Data Label to the Last Point

To label only the last point in an Excel chart, click the data series once, click its final point again to select just that point, then right-click and choose Add Data Label. Excel adds a label to that point without labeling the rest of the series; if the final point changes frequently, use a helper series so the label follows the data automatically.

What a data label identifies

A data label displays information about a plotted value, such as its number, category, or series name. In a line chart with monthly sales, for example, a label on the December point can show the final sales figure while the other eleven points remain unlabeled. This keeps attention on the latest result and avoids filling the chart with text.

Excel treats a point as an individual member of a data series. Selecting the series and adding labels normally labels every point in it. Selecting one point within the series first lets you add a label to that point alone. The distinction is easy to miss because a chart point is small and a single click can select the whole series rather than the individual marker.

This technique applies to common chart types, including line, column, bar, and scatter charts. What the label looks like depends on the chart and the data: a line chart point may be a marker, while a column chart point is a bar. The goal is the same—select the one data point, not the whole series.

Add a label to one point in Excel for Windows

Click the chart to activate it, then click the data series that contains the final point. You should see selection handles or highlighting on the series.
Click the last point a second time. Pause briefly between clicks; clicking too quickly can be treated as a double-click. The individual marker, column, or bar should now appear selected on its own.
Right-click the selected point and choose Add Data Label from the context menu. Excel places a label beside that point.
If the label is hard to read or overlaps the chart, select it and adjust its position or appearance using the data-label formatting options.

For a line chart, “last” usually means the rightmost plotted point, but that is only true if the category order runs from earlier to later. In a chart whose categories are reversed, the latest date may be on the left. Check the category axis rather than assuming that the right edge always represents the newest value.

If selecting the point with two clicks is awkward, another route is to add labels to the whole series, then remove the unwanted labels individually. Select the chart, go to Chart Design > Add Chart Element > Data Labels, and choose a label position. Click a data label once to select all labels in that series, then click the unwanted label again to select only that label and press Delete. Repeat for every label except the final one. This method is more laborious but can be easier when markers are tiny.

Choose what the label displays

Excel commonly displays the point’s value by default. You can change the contents or placement by selecting the label and opening the formatting pane: right-click the label and choose Format Data Labels. Under Label Options, choose the information to show, such as Value, Category Name, or Series Name, when those options apply to the chart. Available choices can vary by chart type.

For a sales chart, a value label might show 18400, while a category label might show Dec. To make the number more meaningful, format the source cells—for example, as currency or with thousands separators—and use the option to link the label’s number format to the source when available. A label’s display format can otherwise differ from the worksheet’s cell format.

Keep the label concise. A single number or short category is usually easier to read than a sentence, particularly on a compact chart. If the chart already has a legend and a clear axis, repeating the series name or category may add clutter rather than useful information.

Keep the label on the latest point as data changes

A label manually applied to one point stays attached to that point in the series. It does not necessarily move to a new row just because new data is appended. If each reporting period adds a new value, the previously labeled point can become the second-to-last point. For a chart that updates regularly, a helper series is a practical way to make only the latest numeric observation eligible for a label.

Suppose dates are in A2:A100 and the numeric chart values are in B2:B100, with at least one numeric value in that range. Put this formula in C2 and fill it down through C100:

=IF(ROW()=LOOKUP(2,1/(ISNUMBER($B$2:$B$100)),ROW($B$2:$B$100)),B2,NA())

For example, if B2:B5 contains 12, 15, 14, and 18, the helper column returns #N/A for the first three rows and 18 for the last. The formula finds the row of the last numeric value in the stated range, returns that row’s value, and returns #N/A for the others. Excel charts normally do not plot #N/A values as ordinary points, so the helper series contributes a point only at the latest numeric observation.

Add column C as a second series to the chart. Select the chart, choose Chart Design > Select Data > Add, and set the series values to the helper range. Use the same category dates as the main series. Then add a data label to the helper series’ one plotted point. For a line chart, formatting this helper series as markers without a connecting line can make its purpose clear: the main series draws the line, while the helper series supplies the latest marker and label.

This setup updates as values change within the specified range, but it does not automatically extend the range beyond row 100. Use a larger planned range or an Excel table if the dataset will grow. The formula is designed for numeric observations; text values and formula results such as an empty string are not treated as numeric points. If the data includes special cases, confirm that the helper column identifies the intended final observation before relying on the chart.

Static labeling versus a helper series

For a finished report or a chart that changes rarely, label the point directly. It is quick, requires no extra worksheet column, and is easy to understand when someone inspects the chart. Its limitation is maintenance: if the identity of the latest point changes, you may have to move the label yourself.

Use a helper series when the chart is refreshed repeatedly and the label should follow the newest numeric entry. It takes more setup and adds a supporting series to the chart, but that series can update along with the worksheet values. You can keep the helper series unobtrusive by matching its marker to the main line and hiding its legend entry if the legend would otherwise be confusing.

Choose a direct point label for a one-time chart, a fixed endpoint, or a quick presentation edit.
Choose a helper series for a recurring report where new data may change which point is last.
Consider a chart title or callout instead if the goal is to explain a result rather than display the point’s actual data value.

Common selection and display problems

The whole series gets labeled. The individual point was probably not selected. Click the series once, then click the target point again more deliberately. If Excel still selects the series, use the add-all-then-delete method and remove the other labels one at a time.

The label appears on the wrong point. Verify that you selected the intended category and that the axis order matches your understanding of “last.” In a chart with multiple series, make sure the selected point belongs to the correct series; each series can have a different final value.

The label is missing or covered. The label may be outside the plot area, obscured by another chart element, or positioned against the chart edge. Try another label position in Format Data Labels, enlarge the chart, or adjust the plot area. A long label at the edge may need more room than a short number.

The helper point is not visible. Check that the helper formula returns a number on the intended final row and that the helper range was added as a chart series. Also check that the helper series uses the appropriate axis and chart type. A point on a secondary axis with a different scale can appear in an unexpected location.

The label does not follow newly appended rows. The chart and helper formula may stop at the old end of the range. Expand both ranges or use an Excel table as the data source so added rows can be incorporated into the chart. A manually selected point label alone does not determine which row counts as latest.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic approach applies: select the chart series, select the individual point, and use the contextual command to add a data label. Ribbon names and the organization of chart controls can differ slightly between Mac and Windows, so look for the chart design and data-label controls if the Windows path is not shown exactly. The point-selection principle is unchanged.

Excel for the web supports common chart editing, but available controls can differ from the desktop application and may depend on the chart and the current web interface. If you cannot select one point or adjust the label options you need in the browser, open the workbook in the Excel desktop app. For a workbook shared across platforms, check the result after editing to ensure that the helper series and label still appear as intended.

Frequently Asked Questions

Can I label only the last point in an Excel line chart?
Yes. Select the line series, select its final marker separately, then right-click and choose Add Data Label. If “last” changes when new data is added, use a helper series to keep the label on the latest numeric point.

How do I label the last point without labeling every point?
Select the individual point before adding the label. If labels have already been added to all points, select each unwanted label individually and press Delete, leaving the final point’s label in place.

Will the label automatically move when I add a new row?
Not reliably when it was applied directly to a point. A direct label remains associated with the point it was added to. A helper series based on the latest numeric row is a better choice for a chart that regularly receives new data, provided its ranges include the new rows.

Can the last-point label show a cell’s text instead of its value?
Yes, where the chart’s label options support it. In Format Data Labels, look for Value From Cells and select the worksheet cells containing the desired text. This is useful for custom wording, but availability and the exact options can vary by Excel version and chart type.

Why does Excel label every point when I only wanted one?
Excel had the entire series selected when you added the label. Click the series once and then click the target point again so only that point is selected. You can also label the series first and remove the other labels individually.

Can I label the final point on a column chart?
Yes. Select the series, select the final column a second time, and add a data label to that individual point. If you use a dynamic helper series instead, check how the added series affects the column layout; a marker-only helper series may be preferable in a combo chart.

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.