Data Analysis with Excel 📈📉📊✅ - 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/uploads/2021/07/top5-chart-for-dashboards.xlsx More on charting & dashboards: ========================== ~ Dashboards: 1️⃣ Project Management Dashboard - https://youtu.be/FXnyKU6xZeI 2️⃣ Fully Interactive dashboard in 15 mins - https://youtu.be/pPpkYB9uG9A 3️⃣ Easy Website Metrics Dashboard - https://youtu.be/QCrVCUkN2XM ~ Charts: 1️⃣ Lollipop chart - https://youtu.be/pRZ2JzvRVlA 2️⃣ Traffic light progress charts - https://youtu.be/C0F_VKlTX1c 3️⃣ 6 Line charts you need to know - https://youtu.be/qxNZj3FEXto #Dashboards #ExcelTrick