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

* TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons)

* TECH-006 - Create a list that automatically sorts alphabetically as you enter data

[iNBiSiLe]

Still relevant and exactly what I needed to see. Thank you!

[arindambhattacharya]

This is simple. I am looking for a chart for every months dynamic change in a single chart

[alpscontrols]

Hello! How hard would it be to modify this Excel sheet so that the chart it outputs could show a numbered list of pictures representing the rankings (1. (apple picture), 2. (banana picture), 3. (blackberries picture), etc.?

[Mrfonseca]

@the excel challange now i want to pit the images in the graph how i can do it? thank you very much

[SamPlays_robloxDuh]

i really love this thank you! but i can't do much better bc my laptop is super old :(.

[firasmusmar]

What will happen if I have repeated rank 3 times not only 2??

[Speedieboy]

The index part doesnt work since it doesnt know the relation between sales rank & name in the first table.

[sujinglanzhou]

love your video. How did you record the excel? how do you add text and shapes on your video?

[sheramaymarquino]

how about if i needed to rank the lowest sales?

[jacksonbodra]

hello sir i have a request. As i am a student so right now all i want is to work on my given projects.
my proect name is create a session plan of all my subjects for this year.
what i want is that i have to show how much our course of this year has been progressed each day(mention days & dates) for all my subjects.
i have to show our progression using GHANTT CHART or by using BAR. i guess it would be better if i show my progression bar for every month instead of showing every day.