title: create a pivotchart with python win32com causes pywintypes.com_error
body: <p>is there anyone can give a example code for creating a pivotchart in excel?
  I have got an example to create a pivottable with pivottable, it works , while when I try to create a pivotchart in the same ways, it will always failed!</p>
  
  <pre><code>import win32com.client
  import os
  
  Excel   = win32com.client.gencache.EnsureDispatch('Excel.Application') 
  win32c  = win32com.client.constants
  wb      = Excel.Workbooks.Add()
  Sheet1  = wb.Worksheets.Add()
  TestData = [['Country','Name','Gender','Sign','Amount'],
               ['CH','Max' ,'M','Plus',123.4567],
               ['CH','Max' ,'M','Minus',-23.4567],
               ['CH','Max' ,'M','Plus',12.2314],
               ['CH','Max' ,'M','Minus',-2.2314],
               ['CH','Sam' ,'M','Plus',453.7685],
               ['CH','Sam' ,'M','Minus',-53.7685],
               ['CH','Sara','F','Plus',777.666],
               ['CH','Sara','F','Minus',-77.666],
               ['DE','Hans','M','Plus',345.088],
               ['DE','Hans','M','Minus',-45.088],
               ['DE','Paul','M','Plus',222.455],
               ['DE','Paul','M','Minus',-22.455]]
  
  for i, TestDataRow in enumerate(TestData):
      for j, TestDataItem in enumerate(TestDataRow):
          Sheet1.Cells(i+2,j+4).Value = TestDataItem
  
  cl1 = Sheet1.Cells(2,4)
  cl2 = Sheet1.Cells(2+len(TestData)-1,4+len(TestData[0])-1)
  PivotSourceRange = Sheet1.Range(cl1,cl2)
  PivotSourceRange.Select()
  
  Sheet2 = wb.Worksheets("Sheet1")
  cl3=Sheet2.Cells(4,1)
  PivotTargetRange=  Sheet2.Range(cl3,cl3)
  PivotTableName = 'ReportPivotTable'
  
  PivotCache = wb.PivotCaches().Create(SourceType=win32c.xlDatabase, SourceData=PivotSourceRange, Version=win32c.xlPivotTableVersion14)
  PivotTable = PivotCache.CreatePivotTable(TableDestination=PivotTargetRange, TableName=PivotTableName, DefaultVersion=win32c.xlPivotTableVersion14)
  PivotChart = PivotCache.CreatePivotChart(ChartDestination="Sheet1")
  Excel.Visible = 1
  cwd = os.getcwd()
  wb.SaveAs(os.path.join(cwd,'test.xlsx'))
  Excel.Application.Quit()
  </code></pre>
  
  <p>it will always report the error:</p>
  
  <pre><code>Traceback (most recent call last):
    File "excelpivotchart.py", line 41, in &lt;module&gt;
      PivotChart = PivotCache.CreatePivotChart(ChartDestination="Sheet1")
    File "C:\Python27\lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x8\PivotCache.py", line 36, in CreatePivotChart
      , XlChartType, Left, Top, Width, Height
  pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146827284), None)
  </code></pre>