python批量生成多个折线图

我们如何在python的“openpyxl”包中绘制两个数据系列（折线图）(How we can draw two series of data in “openpyxl” package of python (line-chart))

假设我们有这个代码：

from openpyxl import Workbook

wb = Workbook()

ws = wb.active

for row in range(1,10):

value = ws.cell(row=row,column=1).value = row+5

for row in range(1,10):

value2 = ws.cell(row=row,column=2).value = row

wb.save("SampleChart.xlsx")

from openpyxl.charts import Reference, Series,LineChart

values = Reference(ws, (1, 1), (9, 1))

series = Series(values, title="First series of values")

chart = LineChart()

chart.append(series)

chart.drawing.name = 'This is my chart'

ws.add_chart(chart)

wb.save("SampleChart.xlsx")

如何将第二列值绘制到相同的折线图？ （并添加legend ）？

Suppose that we have this code:

from openpyxl import Workbook

wb = Workbook()

ws = wb.active

for row in range(1,10):

value = ws.cell(row=row,column=1).value = row+5

for row in range(1,10):

value2 = ws.cell(row=row,column=2).value = row

wb.save("SampleChart.xlsx")

from openpyxl.charts import Reference, Series,LineChart

values = Reference(ws, (1, 1), (9, 1))

seri