当前位置：网站首页>openpyxl绘制饼图

openpyxl绘制饼图

2022-07-15 17:33:00 【奋斗中的打工人】

效果

请添加图片描述

代码

from openpyxl import Workbook

from openpyxl.chart import (
    PieChart,
    ProjectedPieChart,
    Reference
)
from openpyxl.chart.series import DataPoint

data = [
    ['Pie', 'Sold'],
    ['Apple', 50],
    ['Cherry', 30],
    ['Pumpkin', 10],
    ['Chocolate', 40],
]

wb = Workbook()  # 新键wb对象
ws = wb.active  # 选择活跃的单元表

for row in data:
    ws.append(row)

pie = PieChart()
labels = Reference(ws, min_col=1, min_row=2, max_row=5)
data = Reference(ws, min_col=2, min_row=1, max_row=5)  # 图表数据区域

pie.add_data(data, titles_from_data=True)
pie.set_categories(labels)
pie.title = "Pies sold by category"  # 图表标题
slice = DataPoint(idx=0, explosion=20)
pie.series[0].data_points = [slice]

ws.add_chart(pie, "D1")

wb.save("pie.xlsx")
原网站

版权声明
本文为[奋斗中的打工人]所创，转载请带上原文链接，感谢
https://blog.csdn.net/summerriver1/article/details/125799908

边栏推荐

猜你喜欢

随机推荐