This Python video tutorial shows how to build a custom and stylish Chart in Excel by Python programming language using xlsxwriter module. Video perfectly fits to Python users who are interesting into Python automation tasks between Python and Excel.
XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format. XlsxWriter can be used to write text, numbers, formulas and hyperlinks to multiple worksheets and it supports features such as formatting and much more, including: 100 percent compatible Excel XLSX files.
This video demonstrate how to create a custom and fully labeled chart with one and two series of data in Excel by Python. Jupyter Notebook framework was used.
The contect of video is:
#1 - 0:05 How to set up a Worksheet in Excel by Python
#2 - 0:54 How to define a Series of Data (I used random data as example dataset)
#3 - 2:09 Create a new Chart object
#4 - 2:39 Add Series of Data to the Chart object
#! - 3:23 Save new Excel file from Python
#5 - 4:10 Change and modify Chart style
#6 - 5:06 Add Data Labels to the Chart and set a Font to these labels
#7 - 6:07 Add Trendline to the Chart (and display an equation trend function)
#8 - 7:36 Add Markers to the graph and give them a style (shape, color, etc.)
#9 - 8:58 Add more than one Series of Data to the Chart (graph) object.
#10 - 10:19 Change Chart type
#11 - 10:51 Build a Chart on the Specific cell in Excel.
#12 - 11:48 XLSXWRITER Official Documentation
Remember that XLSXWRITER support all standard colors as green, red, black, etc. and HEX color codes also.
Important to know: XLSXWRITER cannot be used to modify or write to an existing Excel XLSX file. Use openpyxl for such purposes. OpenPyxl can read existing excel files and write data back to it.
I hope this video help you to build a really impressive and full custom made charts in Excel in Python side. I am sure that this is important for construct Python based automation systems in business world. Xlsxwriter is like a bridge between Python and Excel.
If you have any comments, please write it down below!
Do not forget to subscribe my channel for getting more cool Python and Data Science videos - https://www.youtube.com/c/VytautasBielinskas
And you always contact me on LinkedIn. - Vytautas Bielinskas
Best regards from Lithuania