def A(): sheetA = wb.create_sheet('전체 출원동향', 0) A그래프data = Data.전체출원동향() for r in dataframe_to_rows(A그래프data, index=False, header=True): sheetA.append(r) sheetA.insert_cols(2) for row, cellobj in enumerate(list(sheetA.columns)[1]): n = '=right(A%d,2)' % (row + 1) cellobj.value = n chartA1 = BarChart() dataA1 = Reference(sheetA, min_col=3, min_row=1, max_row=21) catsA1 = Reference(sheetA, min_col=2, min_row=2, max_row=21) chartA1.add_data(dataA1, titles_from_data=True) chartA1.set_categories(catsA1) chartA1.y_axis.majorGridlines = None chartA2 = LineChart() dataA2 = Reference(sheetA, min_col=4, min_row=1, max_row=21) chartA2.add_data(dataA2, titles_from_data=True) chartA2.y_axis.majorGridlines = None chartA2.y_axis.axId = 2000 # y축 위치 변경 chartA2.y_axis.crosses = 'max' # 그래프 합치기 chartA1 += chartA2 chartA1.width = 15 chartA1.height = 10 chartA1.legend.position = 't' chartA1.graphical_properties = GraphicalProperties( ln=LineProperties(noFill=True)) # 테두리 제거 sheetA.add_chart(chartA1, 'F2') global savepath savepath = Data.Save()