Python | Plotting charts in excel sheet with data tools using XlsxWriter module | Set – 2 (original) (raw)

import xlsxwriter

workbook = xlsxwriter.Workbook( 'Example5_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.set_high_low_lines()

chart2.add_series({

`` 'categories' : '= Sheet1 !$A$2:$A$7' ,

`` 'values' : '= Sheet1 !$B$2:$B$7' ,

})

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' : 20 , 'y_offset' : 5 })

workbook.close()