workbook = xlsxwriter.Workbook('chart_column.xlsx')
worksheet = workbook.add_worksheet()
bold = workbook.add_format({'bold': 1})
headings = ['Number', 'Batch 1', 'Batch 2']
data = [[2, 3, 4, 5, 6, 7], [10, 40, 50, 20, 10, 50], [30, 60, 70, 50, 40, 30]]
worksheet.write_row('A1', headings, bold)
worksheet.write_column('A2', data[0])
worksheet.write_column('B2', data[1])
worksheet.write_column('C2', data[2])
chart = workbook.add_chart({'type': 'column'})
chart.add_series({'name': '=Sheet1!$A$1', 'categories': '=Sheet1!$A$2:$A$7',
    'values': '=Sheet1!$B$2:$B$7'})
chart.set_title({'name': '=CONCATENATE(Sheet1!$A$2, " to ", Sheet1!$B$2)'})
worksheet.insert_chart('E2', chart)
workbook.close()
How to concatenate string cell contents