How To Create a Chart Using the API?

Method

cht=sht.api.ChartObjects().Add(20,200,355,211).Chart

cht.SetSourceData(sht.api.Range(‘A1:H7’),1)

cht.ChartType=xw.constants.ChartType.xlColumnClustered

cht.HasTitle=True

Sample Code

#Create Chart - xlwings API

import xlwings as xw
import os

root = os.getcwd()
app = xw.App(visible=True, add_book=False)
wb=app.books.open('GDP.xlsx',read_only=False)
sht=wb.sheets('Sheet1')

cht=sht.api.ChartObjects().Add(20,200,355,211).Chart
cht.SetSourceData(sht.api.Range('A1:H7'),1)
cht.ChartType=xw.constants.ChartType.xlColumnClustered
cht.HasTitle=True

#wb.save()
#wb.close()
#app.kill()