Create a Top 5 Dynamic Chart with this CRAZY Trick 💡

We can make a cool & interactive Top 5 Chart using Excel pivot tables & simple formulas. Try this next time you are making a report or dashboard and impress everyone.

In this video:
==========
0:00 - Intro & Creating the pivot table
0:58 - Adjusting Pivot settings
1:40 - Calculations for top 5 chart
2:09 - Adding the chart & customizing it
3:12 - Making the chart presentable 🤩
5:51 - More on dashboards & charting


Sample file:
==========
https://chandoo.org/wp/wp-content/upl...

More on charting & dashboards:
==========================
~ Dashboards:
1️⃣ Project Management Dashboard -    • Make an awesome Project Management Da...  
2️⃣ Fully Interactive dashboard in 15 mins -    • Call Centre Dashboard in Excel 📈📊 (Ea...  
3️⃣ Easy Website Metrics Dashboard -    • Make an Excel Dashboard in just 15 mi...  
~ Charts:
1️⃣ Lollipop chart -    • Try this yummy Lollipop Chart 🍭  (Exc...  
2️⃣ Traffic light progress charts -    • Traffic Light Chart in Excel - PM Das...  
3️⃣ 6 Line charts you need to know -    • 6 Must have line charts for business ...  


#Dashboards #ExcelTrick