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

• #science_technology
• #chandoo
• #chandooorg
• #excel
• #spreadsheets
• #excel_dashboards_with_slicers
• #excel_dashboard_examples
• #dashboard_excel
• #top_5_chart_in_excel
• #dynamic_chart_in_excel
• #interactive_charts_for_dashboards
• #how_to_create_a_top_5_list_in_excel
• #pivot_table_excel
• #interactive_excel_dashboard_examples
• #excel_charting