使用openpyxl创建条形图，日期在x轴上

import openpyxl

workbook = openpyxl.load_workbook('filename.xlsx')

worksheet = workbook['Sheet1']

chart = openpyxl.chart.BarChart()

data = openpyxl.chart.Reference(worksheet, min_col=2, min_row=2, max_col=3, max_row=7)

categories = openpyxl.chart.Reference(worksheet, min_col=1, min_row=2, max_row=7)

chart.add_data(data, titles_from_data=True)
chart.set_categories(categories)

chart.title = "Bar Chart"
chart.x_axis.title = "Date"
chart.y_axis.title = "Value"

worksheet.add_chart(chart, "E1")

workbook.save('filename.xlsx')