title: Creating a a range within a databodyrange
body: <p>I have a sub that updates a graph with the series based within a table. However, the first row of the table is blank and I want to omit that from my series collection. I thought of creating a range within my databody range and use that. This is my code:</p>
  
  <pre><code>Sub UpdateGraph()
  
  Dim rng_pf As Variant, rng_bm As Variant, rng_date As Variant,
  Dim lr as integer
  
  ' Defining ranges
  With ThisWorkbook.Sheets("Time series")
           lr = .ListObjects(1).ListColumns(1).Range.Rows.Count + 6 ' This corresponds to the last row in my table
           rng_pf = .ListObjects(1).ListColumns("PF").DataBodyRange(2, lr) ' &lt;-- This doesnt work
           rng_bm = .ListObjects(1).ListColumns("BM").DataBodyRange(2, lr)
           rng_date = .ListObjects(1).ListColumns("Date").DataBodyRange(2, lr)
  End With
  
  ' Updating chart
  With Sheets(1).ChartObjects("Chart 1").Chart
      .FullSeriesCollection(1).Values = rng_pf
      .FullSeriesCollection(2).Values = rng_bm
      .FullSeriesCollection(1).XValues = rng_date
      .FullSeriesCollection(2).XValues = rng_date
  End With
  
  End sub
  </code></pre>
  
  <p>I thought of creating an array that is based on the databodyrange and then removing the first element of the array, but that seems to be overkill.
  When running my code I get that rng_pf is <code>Empty</code>.
  My table:
  <a href="https://i.stack.imgur.com/x18wB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/x18wB.png" alt="enter image description here"></a></p>