将数据标签添加到excel中序列中的最后一个点

I have around 50 charts in an excel worksheet which I should update every month. I need a VBA code which would add data labels to the last point in the data series, to all the charts in the worksheet. My each Chart has 3 series, but I need to add labels for that month's data(latest point) to ONLY ONE series which would be YTD amount. I have no knowledge in writing VBA code. I have seen couple codes and tried copying and making small changes, but no code suits my requirement. I don't want to make 50+ changes every month manually, so any thing that would address my issue would be very helpful. I greatly appreciate your help!I have around 50 charts in an excel worksheet w