title: VBA Count number of series in a chartObject
body: <p>I know this seems straightforward but it doesn't seem to work for me.
  I have a chart on "Sheet1". It is the only chart on the sheet. I want to get the number of series in the chart. So I use:</p>
  
  <pre><code>Debug.Print ThisWorkbook.Sheets("Sheet1").ChartObjects(1).SeriesCollection.Count
  </code></pre>
  
  <p>to get the answer in the immediate window. However VBA gives me a "Object doesn't support property or method" error. Any ideas?</p>