打开EXCEL.xlsx,选取“月份”行(A2:G2)和“月平均值”行(A6:G6)数据区域的内容建立“折线图”,图表标题为“月平均降雪量统计图”,图例靠上;将图表插入到表的A9:G25单元格区域内,将工作表命名为“月平均降雪量统计表”。保存EXCEL.xlsx。
工作表
代码:
from openpyxl import load_workbook
from openpyxl.chart import LineChart, Reference
wb = load_workbook("excel.xlsx")
ws = wb.active
chart = LineChart()
chart.title = "月平均降雪量统计图"
chart.y_axis.title = "月平均值"
chart.x_axis.title = "月份"
value = Reference(ws, min_col = 1, min_row = 6, max_col =7)
chart.add_data(value, titles_from_data = True, from_rows = True)
categories = Reference(ws, min_col =2, min_row = 2, max_col = 7)
chart.set_categories(categories)
ws.add_chart(chart, "A9")
ws.title = "月平均降雪量统计表"
wb.save("excel.xlsx")
结果: