title: Python and win32com.client seem to be missing methods, in particular SetSourceData
body: <p>I'm working on using Python to automate some Excel data analysis. I have most of the basics down, but I can't seem to find any way to call <code>SetSourceData</code> or <code>SeriesCollection</code> successfully. I've read <a href="https://stackoverflow.com/questions/6339115/python-extra-excel-chart-series-with-win32com">this post</a> (and all the others) and found it hopeful, but it doesn't seem to match my experience. I'm using Python 2.7.3, 32 bit on a Windows machine.</p>
  
  <p>Has anyone successfully used <code>SetSourceData</code> or <code>SeriesCollection</code>?</p>
  
  <p>Here's a simplified version of the code I'm using and the error:</p>
  
  <pre><code>chart = chartSheet.ChartObjects(1)
  
  chart.SetSourceData(chartSheet.Range("A1:B2"),PlotBy=2) 
  </code></pre>
  
  <p>I specify <code>PlotBy</code> because of <a href="http://msdn.microsoft.com/en-us/library/ms178843%28v=vs.80%29.aspx" rel="nofollow noreferrer">this</a>, but I doubt it matters</p>
  
  <p>And the error:</p>
  
  <pre><code>raise AttributeError("'%s' object has no attribute '%s'" % (repr(self), attr))
  
  AttributeError: '&amp;lt;win32com.gen_py.Microsoft Excel 14.0 Object Library.ChartObject instance at 0x68557120&amp;gt;' object has no attribute 'SetSourceData'
  </code></pre>
  
  <p>ARGH. Should I look into IronPython? (I've found a few other things that are specified in the MSDN documentation but don't seem to work in Python... but can't remember them now.)</p>