在Excel中使用xlsxwriter创建图表，该图表不随Python中的单元格移动或调整大小

import xlsxwriter

workbook = xlsxwriter.Workbook('example.xlsx')
worksheet = workbook.add_worksheet()

worksheet.write('A1', 'Data 1')
worksheet.write('A2', 100)
worksheet.write('A3', 200)
worksheet.write('B1', 'Data 2')
worksheet.write('B2', 300)
worksheet.write('B3', 400)

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

chart.set_x_axis({'name': 'X-axis', 'min': 0, 'max': 5})
chart.set_y_axis({'name': 'Y-axis', 'min': 0, 'max': 500})

chart.add_series({'values': '=Sheet1!$A$2:$A$3', 'name': 'Data 1'})
chart.add_series({'values': '=Sheet1!$B$2:$B$3', 'name': 'Data 2'})

worksheet.insert_chart('D1', chart)

workbook.close()