title: Add data labels to the last point in a series in excel
body: <p>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!</p>