title: Excel VBA chart, show data label on last point only
body: <p>I want to add data labels to only the final point on my line graph, at the moment I am using the below, which works fine but only if I know what number the final point is.
  I've done a lot of searching and found the points(points.count) object in excel help but I can't seem to make it work for me.
  Please can you suggest a way of only showing the last point on my chart or (ideally) all charts on a worksheet.</p>
  
  <pre><code>Sub Data_Labels()
  '
  ' Data_Labels Macro
  
      ActiveSheet.ChartObjects("Menck Chart").Activate
      ActiveChart.SeriesCollection(1).DataLabels.Select
      Selection.Delete
      ActiveSheet.ChartObjects("Menck Chart").Activate
      ActiveChart.SeriesCollection(1).Select
      ActiveChart.SeriesCollection(1).Points(59).Select
      ActiveChart.SeriesCollection(1).Points(59).ApplyDataLabels
      ActiveChart.SeriesCollection(1).DataLabels.Select
      Selection.Format.TextFrame2.TextRange.Font.Size = 9
  
  
  End Sub
  </code></pre>