Adding a data label to the last point on a chart

[Danny318]

I want to easily and automatically add a data label only to the last point on a chart. I am currently using macro but don't want to. Is there a way to set up the charts to just put the last point in a series without doing it manually?
Thank you in advance!

 

[JamesCanale]

In this case, I would make a three more data sets, but they would be filtered for only the last data value. Graph those three too. They will overlay the last point of the original three sets. Label those, but don't have any line, border, or fill for the actual points.

 

[Danny318]

In this case, I would make a three more data sets, but they would be filtered for only the last data value. Graph those three too. They will overlay the last point of the original three sets. Label those, but don't have any line, border, or fill for the actual points.

I actually only have one data series/line to worry about. The example shows 4 lines. Does this make it easier? Not sure I understand your solution. Novice user. lol Thanks.

 

[JamesCanale]

Here is my data set, and next to it is the last data point.

MrExcelPlayground19.xlsx
	D	E	F	G
4	X	Y	X2	Y2
5	1	10	5	24
6	2	13
7	3	16
8	4	20
9	5	24
Sheet6

Cell Formulas
Range	Formula
F5	F5	=MAX(Table2[X])
G5	G5	=VLOOKUP(F5,Table2,2,FALSE)

I graph them both. The main data gets points and lines in the formatting. The second data set - the point - gets no marker, but it does get data labels. So if you add data to X and Y, X2 and Y2 get updated and automatically graphed.