import xlsxwriter
workbook = xlsxwriter.Workbook('2_2.xlsx')
work_sheet = workbook.add_worksheet('琪哥消费')
format_dic = {
'bold':True,
    'font_color':'#DC143C',
    'font_size':20
}
text_format = workbook.add_format(format_dic)
header = ['门票总额','旅途费用总额','购物总消费','年消费总额']
data = [742.6,4399,1298]
data.append(sum(data))
for col in range(len(header)):
    work_sheet.write(0,col,header[col],text_format)
for col in range(len(data)):
    work_sheet.write(1,col,data[col],text_format)
work_sheet.set_column(0,len(header),25)

chart1 = workbook.add_chart({'type':'column'})
chart1.add_series({
'categories':['小慕消费',0,0,0,2 ],
    'vallues':['小慕消费',1,0,1,2 ]
})
chart1.set_title({'name':'小慕消费统计'})
chart1.set_legend({'none':True})
work_sheet.insert_chart(row=4,col=0,chart=chart1)
chart2 = workbook.add_chart({'type':'pie'})
chart2.add_series({
'categories': ['小慕消费', 0, 0, 0, 2],
    'vallues': ['小慕消费', 1, 0, 1, 2]
})
chart2.set_title({'name':'小慕消费统计图'})
work_sheet.insert_chart(row=4,col=4,chart=chart2)
workbook.close()

C:\Users\Administrator\PycharmProjects\pythonProject\venv\Scripts\python.exe D:/python/day1/c2/2_2.py

C:\Users\Administrator\PycharmProjects\pythonProject\venv\lib\site-packages\xlsxwriter\chart.py:124: UserWarning: Must specify 'values' in add_series()

  warn("Must specify 'values' in add_series()")

Traceback (most recent call last):

  File "D:/python/day1/c2/2_2.py", line 34, in <module>

    workbook.close()

  File "C:\Users\Administrator\PycharmProjects\pythonProject\venv\lib\site-packages\xlsxwriter\workbook.py", line 320, in close

    self._store_workbook()

  File "C:\Users\Administrator\PycharmProjects\pythonProject\venv\lib\site-packages\xlsxwriter\workbook.py", line 685, in _store_workbook

    xml_files = packager._create_package()

  File "C:\Users\Administrator\PycharmProjects\pythonProject\venv\lib\site-packages\xlsxwriter\packager.py", line 138, in _create_package

    self._write_chart_files()

  File "C:\Users\Administrator\PycharmProjects\pythonProject\venv\lib\site-packages\xlsxwriter\packager.py", line 214, in _write_chart_files

    raise EmptyChartSeries("Chart%d must contain at least one "

xlsxwriter.exceptions.EmptyChartSeries: Chart1 must contain at least one data series. See chart.add_series().

进程已结束,退出代码1