使用Python xlswriter向Excel散点图添加自定义字符串标签

import xlsxwriter

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

data = [
    [1, 2, 'A'],
    [3, 4, 'B'],
    [5, 6, 'C'],
    [7, 8, 'D'],
]

for row, col, label in data:
    worksheet.write(row, col, label)

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

chart.add_series({
    'categories': '=Sheet1!$A$1:$A$4',
    'values': '=Sheet1!$B$1:$B$4',
    'text': '=Sheet1!$C$1:$C$4',
})

worksheet.insert_chart('E1', chart)

workbook.close()