TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically

Learn how to create a Top 5 Chart (or a Pareto Chart) that automatically updates and sorts data (descending) as you enter the data in Excel.

In this video you will use the SUM formula, the COUNTIF formula, the MATCH formula, the INDEX formula, the RANK.EQ formula, as well as a Bar Chart, etc.

I hope this tool is something you can use in your daily routine so you get more with less effort.

If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.

Thank you for watching.
Check out some of our previous videos in the links below:

* TECH-008 - Create a chart with stacked pictures
https://www.youtube.com/watch?v=K7bAL5tkSMw

* TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons)
https://www.youtube.com/watch?v=HnlmqZilcKU

* TECH-006 - Create a list that automatically sorts alphabetically as you enter data
https://www.youtube.com/watch?v=V_zd81h_4hY

Видео TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically канала The Excel Challenge