import
xlsxwriter
workbook
=
xlsxwriter.Workbook(
'chart_gradient1.xlsx'
)
worksheet
=
workbook.add_worksheet()
bold
=
workbook.add_format({
'bold'
:
1
})
headings
=
[
'Number'
,
'Batch 1'
,
'Batch 2'
]
data
=
[
[
2
,
3
,
4
,
5
,
6
,
7
],
[
10
,
40
,
50
,
20
,
10
,
50
],
[
30
,
60
,
70
,
50
,
40
,
30
],
]
worksheet.write_row(
'A1'
, headings, bold)
worksheet.write_column(
'A2'
, data[
0
])
worksheet.write_column(
'B2'
, data[
1
])
worksheet.write_column(
'C2'
, data[
2
])
chart
=
workbook.add_chart({
'type'
:
'column'
})
chart.add_series({
'name'
:
'= Sheet1 !$B$1'
,
'categories'
:
'= Sheet1 !$A$2:$A$7'
,
'values'
:
'= Sheet1 !$B$2:$B$7'
,
'gradient'
: {
'colors'
: [
'# 963735'
,
'# F1DCDB'
]}
})
chart.add_series({
'name'
:
'= Sheet1 !$C$1'
,
'categories'
:
'= Sheet1 !$A$2:$A$7'
,
'values'
:
'= Sheet1 !$C$2:$C$7'
,
'gradient'
: {
'colors'
: [
'# E36C0A'
,
'# FCEADA'
]}
})
chart.set_title ({
'name'
:
'Chart With Gradient Fills'
})
chart.set_x_axis({
'name'
:
'Test number'
})
chart.set_y_axis({
'name'
:
'Sample length (mm)'
})
chart.set_legend({
'none'
:
True
})
worksheet.insert_chart(
'D2'
, chart,
{
'x_offset'
:
25
,
'y_offset'
:
10
})
workbook.close()