chart3.title = "合計by時段"
data = Reference(wsheet,
min_col=wsheet.min_column + 1,
min_row=wsheet.min_row,
max_row=wsheet.max_row)
cats = Reference(wsheet,
min_col=wsheet.min_column,
min_row=wsheet.min_row + 1,
max_row=wsheet.max_row)
chart3.add_data(data, titles_from_data=True)
chart3.set_categories(cats)
wsheet.add_chart(chart3, "C2")
wsheet = wbook["By區和時段"]
chart4 = BarChart()
chart4.styles = range(0, len(idx3) + 1)
chart4.height = 14
chart4.width = 22
chart4.title = "計數-區和時段"
chart4.type = "col"
chart4.grouping = "percentStacked" #百分比堆疊圖
chart4.overlap = 100
data = Reference(wsheet,
min_col=wsheet.min_column + 1,
max_col=wsheet.max_column,
min_row=wsheet.min_row,
max_row=wsheet.max_row)
cats = Reference(wsheet,
min_col=wsheet.min_column,
min_row=wsheet.min_row + 1,
max_row=wsheet.max_row)
