先准备一份简单的数据:
data_rows = [
["日期", "案例数", "验收通过数"],
["2022-08-01", 727, 659],
["2022-08-02"...701],
["2022-08-05", 725, 712],
["2022-08-08", 725, 717],
["2022-08-11", 725, 722],
]
预期的效果就是横坐标是日期...= workbook.active
data_rows = [
["日期", "案例数", "验收通过数"],
["2022-08-01", 727, 659]...x_axis)
bar_chart.title = "案例验收情况"
bar_chart.y_axis.title = "数量"
bar_chart.x_axis.title = "日期...filename)
if __name__ == "__main__":
main("bar_chart.xlsx")
运行代码,就会生产 bar_chart.xlsx 文件,打开后就会看到预期的效果图