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)
Download py file : github.com/yasser64b/Python-E...
Video 1: • Python Excel 1/5: Writ...
Video 2: • Python Excel 2/5: auto...
My office tools:
- Microphone I use for voice recording: amzn.to/3teRVL3
- The HD Monitor I used for my work : amzn.to/3hjWijt
-Keyboard I use for coding: amzn.to/3BDE6ZF
- Wireless Computer Mouse I use: amzn.to/3n1shZi
-The Headphone I use: amzn.to/3mYdvCn
Books I read:
- Rich Dad Poor Dad: amzn.to/2Yun3Lv
-The 7 Habits of Highly Effective People : amzn.to/2WN6Y2r
-Think and Grow Rich : amzn.to/2WKR21d
-Zero to One : amzn.to/3kW9eNl
-Awaken the Giant Within : amzn.to/3h2DlRX

[@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!

[@nagashreeurs5110]

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

[@kiranshankar782]

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

[@sahilmakandar773]

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)

[@thrivedhguntreddi4971]

how to remove gridlines?