from openpyxl.chart import Series, LineChart, Referencefrom openpyxl import Workbook, load_workbook 最终效果图如下: