def create_avg_chart(workbook, worksheet, min_col, min_row, max_col, max_row): chart = LineChart() #Sets titles on graph chart.y_axis.title = '5S Audit Socre Average' chart.x_axis.title = '5S Weekly Audit Dates' chart.title = 'Past ' + string_weeks + ' Weeks Average Score For 539' #Gets the data from the table data = Reference(worksheet, min_col=min_col, min_row=min_row + 14, max_col=max_col, max_row=max_row) #Gets the Dates from the first row and stores them in a variable dates = Reference(worksheet, min_col=min_col, min_row=min_row, max_col=max_col, max_row=max_row - 14) #Creates a series using the data collected from the specified rows of the table series = Series(data, title='Building 539') #Sets the marker on the chart to be a triangle series.marker.symbol = "triangle" #Adds the data and date labels to the chart chart.append(series) chart.set_categories(dates) chart.dataLabels = DataLabelList() chart.dataLabels.showVal = True #Adds the chart to the worksheet at cell M18 and saves the file worksheet.add_chart(chart, 'K18') workbook.save(wb_name)
column=_col_2).value # 表4写数据 for _col_dst, _col_src in zip(range(3, 3 + week_num_r), range(7, 7 + week_num_r)): for _row_dst, _row_src in zip(range(2, 11), range(1623, 1632)): datasheet_4.cell(row=_row_dst, column=_col_dst).value = _ws.cell( row=_row_src, column=_col_src).value # 生成表4图标 chart4_1 = BarChart() data1 = Reference(datasheet_4, min_col=4, min_row=7, max_col=9) cats1 = Reference(datasheet_4, min_col=4, min_row=1, max_col=9) chart4_1.add_data(data1, titles_from_data=False, from_rows=True) chart4_1.y_axis.majorGridlines = None chart4_1.set_categories(cats1) chart4_1.title = '融合终端返修情况' chart4_2 = LineChart() data2 = Reference(datasheet_4, min_col=4, min_row=9, max_col=9) chart4_2.add_data(data2, titles_from_data=False, from_rows=True) chart4_2.y_axis.axId = 200 chart4_2.y_axis.crosses = "max" chart4_1 += chart4_2 chart4_2.dataLabels = DataLabelList() chart4_2.dataLabels.showVal = True datasheet_4.add_chart(chart4_1, "C12") # 保存文件 outwb.save("datasheet1.xlsx")