title: excel: get index of current chart
body: <p>I create a new chart with</p>
  
  <pre><code>Sheets("DatenFilledChart").Select
  ActiveSheet.Shapes.AddChart.Select
  ActiveChart.ChartType = xlArea
  ActiveChart.SetSourceData Source:=Range("DatenFilledChart!$B$4:$B$1004")
  ActiveChart.SeriesCollection(1).XValues = "=DatenFilledChart!$A$4:$A$1004"
  ActiveChart.SeriesCollection(1).Name = "=DatenFilledChart!$B$1"
  </code></pre>
  
  <p>In order to work with the current chart I want to save its index with</p>
  
  <pre><code>indexOfChart = ActiveChart.Index
  </code></pre>
  
  <p>That however fails with</p>
  
  <blockquote>
    <p>The method Index is invalid for a object _Chart</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>