An introduction to the creation of Excel files with charts using Pandas and XlsxWriter.
import pandas as pd
...
writer = pd.ExcelWriter('farm_data.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1')
workbook = writer.book
worksheet = writer.sheets['Sheet1']
chart = workbook.add_chart({'type': 'column'})
...
The charts in this document are heavily influenced by the output of Vincent a data visualisation tool that is also integrated with Pandas.
Contents: