Python | Plotting column charts in excel sheet using XlsxWriter module (original) (raw)

import xlsxwriter

workbook = xlsxwriter.Workbook( 'chart_column2.xlsx' )

worksheet = workbook.add_worksheet()

bold = workbook.add_format({ 'bold' : 1 })

headings = [ 'Number' , 'Batch 1' , 'Batch 2' ]

data = [

`` [ 2 , 3 , 4 , 5 , 6 , 7 ],

`` [ 80 , 80 , 100 , 60 , 50 , 100 ],

`` [ 60 , 50 , 60 , 20 , 10 , 20 ],

]

worksheet.write_row( 'A1' , headings, bold)

worksheet.write_column( 'A2' , data[ 0 ])

worksheet.write_column( 'B2' , data[ 1 ])

worksheet.write_column( 'C2' , data[ 2 ])

chart1 = workbook.add_chart({ 'type' : 'column' , 'subtype' : 'stacked' })

chart1.add_series({

`` 'name' : '= Sheet1 !$B$1' ,

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

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

})

chart1.add_series({

`` 'name' : [ 'Sheet1' , 0 , 2 ],

`` 'categories' : [ 'Sheet1' , 1 , 0 , 6 , 0 ],

`` 'values' : [ 'Sheet1' , 1 , 2 , 6 , 2 ],

})

chart1.set_title ({ 'name' : 'Results of data analysis' })

chart1.set_x_axis({ 'name' : 'Test number' })

chart1.set_y_axis({ 'name' : 'Data length (mm)' })

chart1.set_style( 11 )

worksheet.insert_chart( 'E2' , chart1)

workbook.close()