openpyxl绘制折线图

效果

代码

from datetime import date

from openpyxl import Workbook
from openpyxl.chart import (
    LineChart,
    Reference,
)

wb = Workbook()  # 创建wb对象
ws = wb.active  # 选取当前活跃到单元表
# 构建绘图数据
rows = [
    ['Date', 'Batch 1', 'Batch 2', 'Batch 3'],
    [date(2015, 9, 1), 40, 30, 25],
    [date(2015, 9, 2), 40, 25, 30],
    [date(2015, 9, 3), 50, 30, 45],
    [date(2015, 9, 4), 30, 25, 40],
    [date(2015, 9, 5), 25, 35, 30],
    [date(2015, 9, 6), 20, 40, 35],
]

for row in rows:
    ws.append(row)

c1 = LineChart()
c1.title = "Line Chart"  # 图表标题
c1.style = 13
c1.y_axis.title = 'Size'  # y轴坐标轴名
c1.x_axis.title = 'Test Number'  # x轴坐标轴名

data = Reference(ws, min_col=2, min_row=1, max_col=4, max_row=7)
c1.add_data(data, titles_from_data=True)

ws.add_chart(c1, "A10")  # 添加到A10单元格

wb.save("/Users/Desktop/line.xlsx")