Python Excel 3/5 : Auto creation of charts in excel using python openpyxl

This video teaches how to automatically create charts in excel using python .
This is video 3 out of five videos teaching how to write and manage data , plot graphs and develop tables, formulas, etc. in Excel spreadsheets using python (openpyxl)

My office tools:

Books I read:

[atombarako]

Very nice review on openpyxl. I have been following this series of 5 videos to learn to handle excel files with python. Thank you!

[nagashreeurs]

Hi.. can u edit series which shown in graph... Legend entry?

[kiranshankar]

How to give x-axis reference values as string like title1, title2...

[sahilmakandar]

How create pivot table using openxlpy library which is equivalent to the following pandas pivot table function?

table = pd.pivot_table(df, values ='A', index =['B', 'C'],
columns =['B'], aggfunc = np.sum)