title: Creating a Dynamic Scatterplot
body: <p>I want to create a scatterplot based on a filtered set of data.</p>
  <p>I found this website: <a href="https://wellsr.com/vba/2018/excel/creating-vba-scatter-plots/" rel="nofollow noreferrer">https://wellsr.com/vba/2018/excel/creating-vba-scatter-plots/</a></p>
  <p>This returns data labels from the first several rows.</p>
  <pre><code>lastrow = Range(&quot;D&quot; &amp; Rows.Count).End(xlUp).Row
  For countryRow = 2 To lastrow
      ochart.SeriesCollection(1).Points(countryRow - 1).DataLabel.Text = Cells(countryRow, 1).Value
  Next countryRow
  </code></pre>
  <p>I want data labels based on the <em>filtered rows</em>. How do I loop through the filtered labels only?</p>