Create a Top 5 Dynamic Chart with this CRAZY Trick 💡
50.6 هزار بار بازدید -
3 سال پیش
-
We can make a cool
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
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
3 سال پیش
در تاریخ 1400/04/29 منتشر شده
است.
50,629
بـار بازدید شده