python 2.7 - Issues creating XlsxWriter chart -

i want show chart of erreur, 1 100, , nb_mesure. can't find error throws means.

this whole code:

#coding=utf-8 import sys reload(sys) sys.setdefaultencoding('utf8')  import xlsxwriter import random  # créater un tableau et  un fiche workbook = xlsxwriter.workbook('tableau.xlsx') worksheeta= workbook.add_worksheet() worksheetb= workbook.add_worksheet()  #fixer le numbre de mesure et le critère nb_mesures = 100 critere = 0.03  #différer la forme format=workbook.add_format()     format.set_border(1)    format_ave=workbook.add_format()     format_ave.set_bold()   format_ave.set_align('center')   format_num=workbook.add_format() format_num.set_num_format('0.00')    format_num.set_align('center')  #créerer le worksheeta worksheeta.write('a1', 'nb_mesures', format_ave) worksheeta.write('b1', 'angle_aleatoire', format_ave) worksheeta.write('c1', 'angle_mesuré',format_ave) worksheeta.write('d1','erreur',format_ave)  worksheeta.set_column(0, 1, 13) worksheeta.set_column(1, 1, 15) worksheeta.set_column(2, 1, 20) worksheeta.set_column(3, 1, 10)  #insérer le data data1 = [] data2 = [] data3 = [] data4 = []  sum1 = 0 sum2 = 0 sum3 = 0  row in range(1, nb_mesures + 1):     b = random.randrange(0, 360)     c = b*(1+0.02)     d = ( - b * 0.02)     sum1 += b     sum2 += c     sum3 += d     data1.append(row)     data2.append(b)     data3.append(c)     data4.append(d)  ave1 = sum1 / nb_mesures ave2 = sum2 / nb_mesures ave3 = sum3 / nb_mesures  #ecrir les data dans le tableau worksheeta.write_column('a2', data1, format_ave) worksheeta.write_column('b2' ,data2, format_num) worksheeta.write_column('c2', data3,  format_num) worksheeta.write_column('d2', data4, format_num) worksheeta.write('a102', 'average', format_ave) worksheeta.write('b102', ave1, format_num) worksheeta.write('c102', ave2, format_num) worksheeta.write('d102', ave3, format_num)  #créer un schéma,below code has problem charta  = workbook.add_chart({'type' : 'line'})  def chart_series(cur_clo):         charta.add_series({              'values': '=sheeta!$d$'+cur_clo+':$d$'+cur_clo,             })  cline in range(2 , 101):     chart_series(str(cline))  worksheeta.insert_chart('f2',charta) charta.set_size({'width': 1000, 'height': 500})  workbook.close() 

there 2 error in program:

1. you referring sheet named sheeta isn't created: program creates excel default sheet1, sheet2, etc.
2. you creating chart series every point on chart.

also, when generating chart series programmatically better use list syntax rather string syntax. replacing add_series() call , function following should fix these errors:

charta.add_series({     'values': ['sheet1', 1, 3, 100, 3], }) 

if getting started see working charts , chart examples sections of documentation.