Uploaded February 2023 | Updated September 2026, 6 hours ago
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Excel charts that are precise but at the same time hand-drawn? Here's a simple Excel trick to get this different drawing look for your charts. Depending on your situation, you may want to add an extra touch to the Excel chart to make it look different.
Maybe your audience is so used to seeing charts, they've stopped to pay attention.
Maybe you're presenting to students and they find charts "boring".
Or perhaps you're creating a draft dashboard that you're presenting to management.
In this video I'll show you a secret trick you can use to easily create such hand-drawn charts that are actually linked to your data. It's ridiculously simple but leaves a lasting impression.
π My Online Courses βΊ xelplus.com/courses
π¬ LINKS to related videos:
Excel Charts & Graphs: Learn the Basics for a Quick Start: youtu.be/DAU0qqh_I-A
Build Impressive Charts: Infographics in Excel: youtu.be/8g9DK5noi1s
β‘οΈ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Excel charts that are precise but at the same time hand-drawn? Here's a simple Excel trick to get this different drawing look for your charts. Depending on your situation, you may want to add an extra touch to the Excel chart to make it look different.
Maybe your audience is so used to seeing charts, they've stopped to pay attention.
Maybe you're presenting to students and they find charts "boring".
Or perhaps you're creating a draft dashboard that you're presenting to management.
In this video I'll show you a secret trick you can use to easily create such hand-drawn charts that are actually linked to your data. It's ridiculously simple but leaves a lasting impression.
π My Online Courses βΊ xelplus.com/courses
π¬ LINKS to related videos:
Excel Charts & Graphs: Learn the Basics for a Quick Start: youtu.be/DAU0qqh_I-A
Build Impressive Charts: Infographics in Excel: youtu.be/8g9DK5noi1s
β‘οΈ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

![The 1-Formula Fix for Excelβs Messiest Tables
Learn Python in Excel: https://www.xelplus.com/course/python-in-excel/
Sales data split across monthly columns? Heres how to reshape it into one clean table, with month, sales, and units each in their own column, using Python inside Excel.
=PY
pd.wide_to_long(sales_data, stubnames=[sales,units], i=sales rep, j=month, sep , suffix=.+).reset_index()
- Type =PY and press Tab to activate Python mode
- wide_to_long turns repeated column groups (like sales_Jan, units_Jan) into rows
- stubnames lists the values youre tracking
- i is your identifier column, like sales rep
- j names the new column that holds the month
- sep matches the separator in your source headers
- suffix=.+ means the leftover text can be anything
- reset_index() keeps everything aligned
- Right-click the Python output and choose Excel Value to drop it into cells
Add a new month to your source data and the table updates on its own.
Uses the pandas wide_to_long function. Check the pandas docs for the full reference.
π¨ Subscribe to Between the Sheets newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
π Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π² Letβs connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/in/leilagharani
#Excel The 1-Formula Fix for Excelβs Messiest Tables](https://i.ytimg.com/vi/aUlGfk7kst0/mqdefault.jpg)








