import
xlsxwriter
workbook
=
xlsxwriter.Workbook(
'Example2_chart.xlsx'
)
worksheet
=
workbook.add_worksheet()
italic
=
workbook.add_format({
'italic'
:
1
})
Data1
=
[
'Subject'
,
'Mid Exam Score'
,
'End Exam Score'
]
Data2
=
[
[
"Math"
,
"Physics"
,
"Computer"
,
"Hindi"
,
"English"
,
"chemistry"
],
[
90
,
78
,
60
,
80
,
60
,
90
],
[
45
,
39
,
30
,
40
,
30
,
60
]
]
worksheet.write_row(
'A1'
, Data1, italic)
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'
:
'line'
})
chart2.add_series({
'categories'
:
'= Sheet1 !$A$2:$A$7'
,
'values'
:
'= Sheet1 !$B$2:$B$7'
,
'data_labels'
: {
'value'
:
1
},
'marker'
: {
'type'
:
'automatic'
},
})
chart2.add_series({
'categories'
:
'= Sheet1 !$A$2:$A$7'
,
'values'
:
'= Sheet1 !$C$2:$C$7'
,
})
chart2.set_title({
'name'
:
'Exam Score Distribution'
})
chart2.set_x_axis({
'name'
:
'Subjects'
})
chart2.set_y_axis({
'name'
:
'Marks'
})
chart2.set_style(
11
)
worksheet.insert_chart(
'D2'
, chart2,
{
'x_offset'
:
25
,
'y_offset'
:
10
})
workbook.close()