pip install openpyxl
python
import openpyxl
python
wb = openpyxl.load_workbook('file.xlsx')
python
sheet = wb['Sheet1']
python
chart = openpyxl.chart.BarChart()
python
data = openpyxl.chart.Reference(sheet, min_col=1, min_row=2, max_col=1, max_row=6)
chart.add_data(data, titles_from_data=True)
python
python
sheet.add_chart(chart, 'B2')
python
wb.save('file.xlsx')
wb.close()