python堆叠面积图_python如何绘制百分比堆积面积图

要在Excel工作表上绘制“堆积面积百分比”图表，请使用类型为“area”的add_chart()

# import xlsxwriter module

import xlsxwriter

# Workbook() takes one, non-optional, argument

# which is the filename that we want to create.

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

# The workbook object is then used to add new

# worksheet via the add_worksheet() method.

worksheet = workbook.add_worksheet()

# Create a new Format object to formats cells

# in worksheets using add_format() method .

# here we create bold format object .

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

# create a data list .

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],

]

# Write a row of data starting