使用xlsxwriter从指定单元格创建图表

import xlsxwriter

workbook = xlsxwriter.Workbook('output.xlsx')

worksheet = workbook.add_worksheet()

data = [10, 20, 30, 40, 50]

worksheet.write_column('A1', data)

chart = workbook.add_chart({'type': 'line'})

chart.add_series({'values': '=Sheet1!$A$1:$A$5'})

chart.set_title({'name': 'Sample Chart'})
chart.set_x_axis({'name': 'X-axis'})
chart.set_y_axis({'name': 'Y-axis'})

worksheet.insert_chart('C1', chart)

workbook.close()