from openpyxl import load_workbook
wb = load_workbook("charts.xlsx")

sheetnames = wb.sheetnames
charts = []

for sheet in sheetnames:
    ws = wb[sheet]
    chart_info = ws._charts
    charts.append(chart_info)