If you're using the same excel sheets over and over again, learn to create a python Dash app that would visualize the data with Plotly graphs.
The Code:
https://github.com/Coding-with-Adam/D...
Plotly Forum:
https://community.plotly.com/
View my book - The Book of Dash:
https://www.amazon.com/Python-Dash-An...
https://github.com/DashBookProject/Pl...
Video layout:
00:00 - Intro & What you will Learn
02:56 - Layout and creating tables
07:38 - Pattern matching callbacks
08:54 - Build the graphs: callback decorator
12:00 - Build the graphs
16:13 - Final remarks & support your learning
************************************************************************
👉 Your support keeps Charming Data running, which is proudly a 100% member-supported educational channel:
Patreon: / charmingdata
GitHub: https://github.com/sponsors/Coding-wi...
YouTube: / @charmingdata