Display the last point's data label in series with VBA

Hello,
I have one Excel sheet containing multiple charts.
Each chart have multiple series.
I want to display the datalabel of the last point only, in all the series of all the charts.
I want to be able to achieve this by VBA.
Also, because of the series are made from dynamic range, so the last point in all the series change when a parameter variate.
How can i do this?
thanks a lot