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