title: Controlling chart type in xlwings
body: <p>How does one control the type of chart when making charts in Excel using <strong>xlwings</strong> from python?</p>
  
  <p>I don't see anything in the current documentation: <a href="http://docs.xlwings.org/chart.html" rel="nofollow">http://docs.xlwings.org/chart.html</a></p>
  
  <p>as in the example given in the quickstart to xlwings:</p>
  
  <pre><code>from xlwings import Workbook, Range, Chart
  wb = Workbook()  # Creates a connection with a new workbook
  Range('A1').value = ['Foo 1', 'Foo 2', 'Foo 3', 'Foo 4']
  Range('A2').value = [10, 20, 30, 40]
  chart = Chart().add()
  chart.set_source_data(Range('A1').table)
  </code></pre>
  
  <p>Then I haven't found a way of controlling what kind of chart is added to the Excel workbook ...</p>