Continuamos con Excel. Crear un gráfico de barras (openpyxl.chart.BarChart()) lo más parecido al que se muestra en la imagen:

from openpyxl import load_workbook
from openpyxl.chart import BarChart, Reference

wb = load_workbook(filename = 'sample_chart.xlsx')
ws = wb.active

data = Reference(ws, min_row=2, min_col=2, max_row=6, max_col=6)
cats = Reference(ws, min_row=1, min_col=2, max_row=1, max_col=6)
chart = BarChart()
chart.add_data(data=data, titles_from_data=True)
chart.set_categories(cats)
chart.title = "My Chart"
chart.y_axis.title = 'Test number'
chart.x_axis.title = 'Sample length (mm)'
# Add chart to the worksheet.
ws.add_chart(chart, 'D1')
wb.save('sample_chart.xlsx')