import
xlsxwriter
workbook
=
xlsxwriter.Workbook(
'chart_pattern.xlsx'
)
worksheet
=
workbook.add_worksheet()
bold
=
workbook.add_format({
'bold'
:
1
})
headings
=
[
'Shingle'
,
'Brick'
]
data
=
[
[
105
,
150
,
130
,
90
],
[
50
,
120
,
100
,
110
],
]
worksheet.write_row(
'A1'
, headings, bold)
worksheet.write_column(
'A2'
, data[
0
])
worksheet.write_column(
'B2'
, data[
1
])
chart
=
workbook.add_chart({
'type'
:
'column'
})
chart.add_series({
'name'
:
'= Sheet1 !$A$1'
,
'values'
:
'= Sheet1 !$A$2:$A$5'
,
'pattern'
: {
'pattern'
:
'shingle'
,
'fg_color'
:
'# 804000'
,
'bg_color'
:
'# c68c53'
},
'border'
: {
'color'
:
'# 804000'
},
'gap'
:
70
,
})
chart.add_series({
'name'
:
'= Sheet1 !$B$1'
,
'values'
:
'= Sheet1 !$B$2:$B$5'
,
'pattern'
: {
'pattern'
:
'horizontal_brick'
,
'fg_color'
:
'# b30000'
,
'bg_color'
:
'# ff6666'
},
'border'
: {
'color'
:
'# b30000'
},
})
chart.set_title ({
'name'
:
'Cladding types'
})
chart.set_x_axis({
'name'
:
'Region'
})
chart.set_y_axis({
'name'
:
'Number of houses'
})
worksheet.insert_chart(
'D2'
, chart, {
'x_offset'
:
25
,
'y_offset'
:
10
})
workbook.close()