import
xlsxwriter
workbook
=
xlsxwriter.Workbook(
'Ex_chart1.xlsx'
)
worksheet
=
workbook.add_worksheet()
bold
=
workbook.add_format({
'italic'
:
1
})
Data1
=
[
'Subject'
,
'Mid Term Score'
,
'End Term Score'
]
Data2
=
[ [
"Math"
,
"Physics"
,
"Biology"
,
"Hindi"
,
"English"
,
"Singing"
],
[
95
,
78
,
80
,
80
,
60
,
65
],
[
90
,
67
,
78
,
70
,
63
,
60
] ]
worksheet.write_row(
'A1'
, Data1, bold)
worksheet.write_column(
'A2'
, Data2[
0
])
worksheet.write_column(
'B2'
, Data2[
1
])
worksheet.write_column(
'C2'
, Data2[
2
])
worksheet.set_column(
'B:C'
,
15
)
chart2
=
workbook.add_chart({
'type'
:
'column'
})
chart2.add_series({
'name'
:
'= Sheet1 !$B$1'
,
'categories'
:
'= Sheet1 !$A$2:$A$7'
,
'values'
:
'= Sheet1 !$B$2:$B$7'
, })
chart2.add_series({
'name'
: [
'Sheet1'
,
0
,
2
],
'categories'
: [
'Sheet1'
,
1
,
0
,
6
,
0
],
'values'
: [
'Sheet1'
,
1
,
2
,
6
,
2
], })
chart2.set_title({
'name'
:
'Exam Score distribution'
})
chart2.set_x_axis({
'name'
:
'Subjects'
})
chart2.set_y_axis({
'name'
:
'Marks'
})
chart2.set_table({
'show_keys'
:
True
})
chart2.set_legend({
'position'
:
'none'
})
worksheet.insert_chart(
'D2'
, chart2,
{
'x_offset'
:
20
,
'y_offset'
:
5
})
workbook.close()