用于Openpyxl图表位置的循环

from openpyxl import Workbook
from openpyxl.drawing.image import Image
from openpyxl.chart import BarChart, Reference

wb = Workbook()
ws = wb.active

data = [
    ['Category', 'Value'],
    ['A', 10],
    ['B', 15],
    ['C', 7],
    ['D', 12]
]

for row in data:
    ws.append(row)

chart = BarChart()
values = Reference(ws, min_col=2, min_row=2, max_row=5, max_col=2)
categories = Reference(ws, min_col=1, min_row=2, max_row=5)
chart.add_data(values, titles_from_data=True)
chart.set_categories(categories)
chart.title = "Chart Title"
chart.x_axis.title = "X Axis"
chart.y_axis.title = "Y Axis"

# 设置图表的位置
chart.anchor = "E3"

ws.add_chart(chart, "E3")