Stop Using Pie Charts (Do THIS Instead)
Leila Gharani
68,094 views
🔥 Create charts that wow your audience. Learn the secrets now, start today! 👉 https://link.xelplus.com/yt-bizcharts...
Still using a pie chart for lots of categories? Even if your boss asks for a pie chart, there’s a better option in Excel.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/better-pie-...
In this video, you’ll learn how to build a clean, professional bar chart that’s better than a pie chart, while keeping all the same info people love about pies (including percent of total). You’ll also make it auto-update and auto-sort with a simple formula setup, so your chart stays readable even when the data changes.
Timestamps:
00:00 Stop sending messy pie charts
00:59 Build the better chart: linked data + bar chart
03:15 How to show % on the bar chart
04:48 Auto-sort the chart with SORT
06:47 Add a dynamic total to the chart title
08:34 Final comparison: pie chart vs readable chart
What you’ll learn:
Why pie charts fall apart with too many slices
A faster, cleaner chart you can actually present
How to add currency labels and percent labels to a bar chart
The “duplicate series” trick to show percentages without clutter
How to keep your source data intact, but make the chart sorted automatically using SORT()
How to add a dynamic total to the chart title (updates as data changes)
If you want to create charts that look like they belong in real reports (and not in a spreadsheet from 2006), this one’s for you.
📨 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:
@leilagharani
🎬 LINKS to related videos:
Fast & Easy! McKinsey Chart in Excel: Stop Making Default Charts! Create McKinse...
The Excel Timeline chart you'll actually keep using: The Excel Timeline chart you'll actually k...
👕 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🧰 Resources I recommend: https://www.xelplus.com/resources/
🛒 More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: 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
20 Comments
She brings unique techniques for us!
She is one of the most creative instructors!
Thank you Leila!
Stop Using Pie Charts (Do THIS Instead)
Leila Gharani
68,094 views
🔥 Create charts that wow your audience. Learn the secrets now, start today! 👉 https://link.xelplus.com/yt-bizcharts...
Still using a pie chart for lots of categories? Even if your boss asks for a pie chart, there’s a better option in Excel.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/better-pie-...
In this video, you’ll learn how to build a clean, professional bar chart that’s better than a pie chart, while keeping all the same info people love about pies (including percent of total). You’ll also make it auto-update and auto-sort with a simple formula setup, so your chart stays readable even when the data changes.
Timestamps:
00:00 Stop sending messy pie charts
00:59 Build the better chart: linked data + bar chart
03:15 How to show % on the bar chart
04:48 Auto-sort the chart with SORT
06:47 Add a dynamic total to the chart title
08:34 Final comparison: pie chart vs readable chart
What you’ll learn:
Why pie charts fall apart with too many slices
A faster, cleaner chart you can actually present
How to add currency labels and percent labels to a bar chart
The “duplicate series” trick to show percentages without clutter
How to keep your source data intact, but make the chart sorted automatically using SORT()
How to add a dynamic total to the chart title (updates as data changes)
If you want to create charts that look like they belong in real reports (and not in a spreadsheet from 2006), this one’s for you.
📨 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:
@leilagharani
🎬 LINKS to related videos:
Fast & Easy! McKinsey Chart in Excel: Stop Making Default Charts! Create McKinse...
The Excel Timeline chart you'll actually keep using: The Excel Timeline chart you'll actually k...
👕 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🧰 Resources I recommend: https://www.xelplus.com/resources/
🛒 More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: 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
:_leilaLightbulb: Interested to create professional business charts in Excel? 👉 https://link.xelplus.com/yt-bizcharts-course