用于创建openpyxl多个图表的for循环

import openpyxl

workbook = openpyxl.load_workbook('example.xlsx')  # 打开已有的Excel文件
# 或者
workbook = openpyxl.Workbook()  # 创建一个新的Excel文件

chart = openpyxl.chart.BarChart()  # 创建柱状图
chart.title = "Sales Data"  # 设置图表标题

# 设置图表数据
data = openpyxl.chart.Reference(worksheet, min_row=1, min_col=1, max_row=10, max_col=3)
categories = openpyxl.chart.Reference(worksheet, min_row=2, min_col=1, max_row=10)
chart.add_data(data, titles_from_data=True)
chart.set_categories(categories)

# 将图表添加到Excel文件中的指定位置
worksheet.add_chart(chart, "E5")

for i in range(1, 5):  # 假设需要创建4个图表
    chart = openpyxl.chart.BarChart()  # 创建柱状图
    chart.title = "Sales Data {}".format(i)  # 设置图表标题

    # 设置图表数据
    data = openpyxl.chart.Reference(worksheet, min_row=1, min_col=i, max_row=10, max_col=i)
    categories = openpyxl.chart.Reference(worksheet, min_row=2, min_col=1, max_row=10)
    chart.add_data(data, titles_from_data=True)
    chart.set_categories(categories)

    # 将图表添加到Excel文件中的指定位置
    worksheet.add_chart(chart, "E{}".format(5 + (i - 1) * 15))