Stop Using Pie Charts (Do THIS Instead)

🔥 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:   / lgharani   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

Make Beautiful Excel Charts Like The Economist (file included)
▶︎

Make Beautiful Excel Charts Like The Economist (file included)

Stop Sending Ugly Pivot Tables to Your Boss
▶︎

Stop Sending Ugly Pivot Tables to Your Boss

Excel Line Chart With Differences? Do THIS!!
▶︎

Excel Line Chart With Differences? Do THIS!!

Stop Doing Extra Work in Excel! (8 Hidden Features)
▶︎

Stop Doing Extra Work in Excel! (8 Hidden Features)

Make Your Excel Tables NEXT LEVEL
▶︎

Make Your Excel Tables NEXT LEVEL

Common Excel Pivot Table Features People Miss (and you?)
▶︎

Common Excel Pivot Table Features People Miss (and you?)

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE
▶︎

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE

The New Excel Trick to Link CSV Files Instantly
▶︎

The New Excel Trick to Link CSV Files Instantly

Mom Called Emergency Meeting About My Pathetic Career—Then Sterling Capital Called...| Peony Revenge
▶︎

Mom Called Emergency Meeting About My Pathetic Career—Then Sterling Capital Called...| Peony Revenge

Stop Making Default Charts! Create McKinsey Visuals in 90s
▶︎

Stop Making Default Charts! Create McKinsey Visuals in 90s

Tuesday, July 21 Morning Prayer for Financial Breakthrough | Trust God to Provide Every Need Today 🙏
▶︎

Tuesday, July 21 Morning Prayer for Financial Breakthrough | Trust God to Provide Every Need Today 🙏

父の葬儀の日、夫は喪服姿の私を駅前に残し、愛人だけを車に乗せて去った。私は泣かずに父の鞄を開けた。五分後、夫のもとへ弁護士から電話が入り、笑顔が消えた――。
▶︎

父の葬儀の日、夫は喪服姿の私を駅前に残し、愛人だけを車に乗せて去った。私は泣かずに父の鞄を開けた。五分後、夫のもとへ弁護士から電話が入り、笑顔が消えた――。

8 Tiny Excel Symbols That Replace Messy Formulas
▶︎

8 Tiny Excel Symbols That Replace Messy Formulas

Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
▶︎

Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)

Compare Two Excel Sheets and Catch Every Single Difference
▶︎

Compare Two Excel Sheets and Catch Every Single Difference

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
▶︎

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Learn to Automate Everything with Power Query in Excel (Download Files)
▶︎

Learn to Automate Everything with Power Query in Excel (Download Files)

Excel Charts & Graphs: Learn the Basics for a Quick Start
▶︎

Excel Charts & Graphs: Learn the Basics for a Quick Start

9 Boring Habits That Will Put You Ahead of 99% of People
▶︎

9 Boring Habits That Will Put You Ahead of 99% of People

Excel's NEW Checkboxes Are Incredibly Cool! Here's why
▶︎

Excel's NEW Checkboxes Are Incredibly Cool! Here's why