TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
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-008 - Create a ba...
* TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons)
• TECH-007 - Create a su...
* TECH-006 - Create a list that automatically sorts alphabetically as you enter data
• TECH-006 - Create a li...
Пікірлер: 19
Still relevant and exactly what I needed to see. Thank you!
This is amazing! Thank you!
Really useful, thank you!
THANK YOU SO MUCH!!!
Thank you
Thank you dude
You are awesome
This is simple. I am looking for a chart for every months dynamic change in a single chart
love your video. How did you record the excel? how do you add text and shapes on your video?
@TheExcelChallenge
6 жыл бұрын
Hello Jing Su. To record my screen I use a piece of software called Camtasia 9 which I bought from TechSmith. I highly recommend it and here is the link: www.techsmith.com/video-editor.html I use the same software to add text and shapes. To learn how to use Camtasia, I took a course from Lynda, which I highly recommend as well and here is the link: www.lynda.com/Camtasia-tutorials/Camtasia-9-Windows-Essential-Training/417150-2.html Good luck creating your own videos!!! T-E-CH
@sujinglanzhou
6 жыл бұрын
The Excel Challenge awesome. thx for sharing we
What will happen if I have repeated rank 3 times not only 2??
how about if i needed to rank the lowest sales?
@the excel challange now i want to pit the images in the graph how i can do it? thank you very much
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.
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.?
i really love this thank you! but i can't do much better bc my laptop is super old :(.
The index part doesnt work since it doesnt know the relation between sales rank & name in the first table.