title: Macro to select last data point in line chart and add a data label
body: <p>I have a line chart with 60 different data series in Excel that updates once a week. In this chart, I would like to program a macro that selects the most recent data points in the line charts and adds a data label in the format 100.00 (number with two decimal places). </p>
  
  <p>I am now using the code below to delete all data labels:</p>
  
  <pre><code>Sub Delete_labels()
  
  ActiveChart.ApplyDataLabels xlDataLabelsShowNone
  
  End Sub
  </code></pre>
  
  <p>To add data labels, I would like to use a code as well. I have been experimenting with the code below:</p>
  
  <pre><code>Sub Add_last_label()
  
  ActiveChart.ApplyDataLabels xlDataLabelsShowLabel, , , , True, False, False, False, False
  
  End Sub
  </code></pre>
  
  <p>However, this code adds data labels to each data point, creating a huge mess. The string ", , , , True, False, False, False, False" must be adapted to only add the last data label in the chart, but I am unsure how.</p>
  
  <p>Does anyone have an idea how to data labels to the last point in each series in the format 100.00 (with two decimal points)? </p>