I would like to show the value of only the last point of all series in a line
chart in excel.
I can do it manually, (click the point in the graph - data labels - show value).
Is it possible to do it automatically, so when I change the data source, the
chart will still show the value of the last point ? Also, I am not very familiar with VBA and attached you will find a sample spreadsheet.
I have used this link below but I was unsuccessful to get it working