Dynamic Scatter Graph (Using the table method) - Data label of the last entry

Good afternoon,

I have created a dynamic scatter graph using the table method. I'd like there to be a data label on the last point of the graph. For instance, in the attached Excel file I have a data label (112,40%) on november 2012, but if I add december (Let's say 115%) the data label will not change (obviously).

I'd like it to self-update to the last point there is (115% in this case).

I can't find an option so my guess is some scary Visual Basic advanced skills are needed....


Thanks on advance.

Libro2.xlsx

Your example did not have a Table so I converted the data to a Table and based the chart on it.
Add another column to the table to display only the last data point. Use this to display a data label on the chart.