使用xlsxwriter实现x轴上的分类值

import xlsxwriter

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

worksheet = workbook.add_worksheet()

categories = ['分类1', '分类2', '分类3', '分类4']

data = [10, 20, 30, 40]

# 写入分类值
worksheet.write_column('A2', categories)

# 写入数据
worksheet.write_column('B2', data)

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

# 设置x轴上的分类值
chart.add_series({
    'categories': '=Sheet1!$A$2:$A$5',
    'values': '=Sheet1!$B$2:$B$5',
})

worksheet.insert_chart('D2', chart)

workbook.close()