import
xlsxwriter
workbook
=
xlsxwriter.Workbook(
'chart_styles.xlsx'
)
chart_types
=
[
'column'
,
'area'
]
for
chart_type
in
chart_types:
worksheet
=
workbook.add_worksheet(chart_type.title())
worksheet.set_zoom(
30
)
style_number
=
1
for
row_num
in
range
(
0
,
90
,
15
):
for
col_num
in
range
(
0
,
64
,
8
):
chart
=
workbook.add_chart({
'type'
: chart_type})
chart.add_series({
'values'
:
'= Data !$A$1:$A$6'
})
chart.set_title ({
'name'
:
'Style % d'
%
style_number})
chart.set_legend({
'none'
:
True
})
chart.set_style(style_number)
worksheet.insert_chart(row_num, col_num, chart)
style_number
+
=
1
data_worksheet
=
workbook.add_worksheet(
'Data'
)
data
=
[
10
,
40
,
50
,
20
,
10
,
50
]
data_worksheet.write_column(
'A1'
, data)
data_worksheet.hide()
workbook.close()