A very complex explanation for a simple concept and very focused on formatting, it's great if we want to learn two things at once; it would have been nice to get real life data example rather than options, thanks
Thank you for the feedback! Hoping the chapters helped to skip to the part a person wanted to hear. For the real examples: pretend the "data" column is called "Defects", and the "Options" column is called "Names", or even "Systems". Then we can see how many defects are coming out of which system, or are created by a certain person - just one example.
@@davidmclachlanproject thanks David, I'll try again as you suggest. At the end I just wanted to see how the conclusion was defined by applying the 80/20 rule so I can use it as guide in real life scenarios. Thanks again.
I really appreciate the way you described the entire process. I eventually utilized the Pareto Chart template I obtained from Someka and it turned out great. Thank you for sharing the video.
I keep getting lost on the part where if I want to select all the data vs copy and paste from chart to chart. I realize you jump for a reason, but that is the MOST important aspect to me. Do you have an updated video with this explanation?
Impossible to follow the part where he 'Formats as a Table' The cursor is COMPLETLEY invisible, too fast, cant recreate how he gets that second smaller 'Format as a table' pop up box. VERY frustrating, had to go to use another TH-cam vid for this. Maybe its just me.
David, question for you sorry if you covered this in your video and I missed it - on the gant chart when tasks are completed am I to adjust the start and end date to reflect the true time it took to complete vs the planned time?
When I try to paste the line onto the original chart the whole chart just disintegrates into a straight line! I tried doing it with both data point on the original chart but then I can not find a way to format the one set of date into a line. Please help :)
Oh no! Does selecting one of the lines and putting it on a different axis help? Otherwise, you could select all three columns of data at once (hold CTRL and drag each column, "Data", "Cumulative" and "Line" to select), create a line chart, and then select the cumulative line, right click and format axis, then select secondary axis. The Pareto line goes on the secondary axis also. Hoping this helps!
Ah, the Pareto line represents the Pareto principle, where 80% of our opportunities come from 20% of the inputs. Once the cumulative percentage line goes over the Pareto line, all the opportunities to the left of it (the bars) are the 80% majority.
Ah - there is no specific reason. Many people will use 80%. Sometimes I find that 80% is too much. The main idea is that a large amount of outcomes will come from a few inputs 🙂
Terrible explanation. Started well but decided to change focus. Why did you decide to lose traction. Should have continued on building the chart individually
This is great, with expert formatting advice. David is the Bob Ross of EXCEL!
Too fast teaching for beginners should've made it bit slow so beginners can follow along while they practically make
A very complex explanation for a simple concept and very focused on formatting, it's great if we want to learn two things at once; it would have been nice to get real life data example rather than options, thanks
Thank you for the feedback! Hoping the chapters helped to skip to the part a person wanted to hear. For the real examples: pretend the "data" column is called "Defects", and the "Options" column is called "Names", or even "Systems". Then we can see how many defects are coming out of which system, or are created by a certain person - just one example.
@@davidmclachlanproject thanks David, I'll try again as you suggest. At the end I just wanted to see how the conclusion was defined by applying the 80/20 rule so I can use it as guide in real life scenarios. Thanks again.
To say you are the best is an understatement
Fast, Efficient, excellent.
I really appreciate the way you described the entire process. I eventually utilized the Pareto Chart template I obtained from Someka and it turned out great. Thank you for sharing the video.
Hi David good day to you. Thank you for this training. I finally found a learning channel for excel that what I need.
Currently I don't really need a Pareto chart, but this is such a great explanation of how to create one, when ever I need it. Thanks a lot.
I keep getting lost on the part where if I want to select all the data vs copy and paste from chart to chart. I realize you jump for a reason, but that is the MOST important aspect to me. Do you have an updated video with this explanation?
Agreed. It was a bit too fast and maybe a bit more explanation would help.
Really amazing video with senior experience in Excel.... thanks a lot
man you are awesome I just done it for my assignment,, thanks a lot
Impossible to follow the part where he 'Formats as a Table' The cursor is COMPLETLEY invisible, too fast, cant recreate how he gets that second smaller 'Format as a table' pop up box. VERY frustrating, had to go to use another TH-cam vid for this. Maybe its just me.
bro what happen at 9:15
Exactly!
Thank You for Your help !!!
Excellent explanation 🙏.
well explained. thanks
He's like the Bob Ross of Excel
Great video. You like spreadsheets the way I do, I really missed my calling
Very helpful
Looks like a combo chart, which Excel includes in its chart choices.
Nicely explained
Thank you
David, question for you sorry if you covered this in your video and I missed it - on the gant chart when tasks are completed am I to adjust the start and end date to reflect the true time it took to complete vs the planned time?
Very good
Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks
David I’m looking for a Pareto chart for Inventory Coordinator do you feel you template will help?
What does the 70% mean?
When formatting as a table I do not get the pop-up box the say my table has headers so I never get the sorting options any help?
why not use the pareto chart in excel?
When I try to paste the line onto the original chart the whole chart just disintegrates into a straight line! I tried doing it with both data point on the original chart but then I can not find a way to format the one set of date into a line. Please help :)
Oh no! Does selecting one of the lines and putting it on a different axis help?
Otherwise, you could select all three columns of data at once (hold CTRL and drag each column, "Data", "Cumulative" and "Line" to select), create a line chart, and then select the cumulative line, right click and format axis, then select secondary axis. The Pareto line goes on the secondary axis also. Hoping this helps!
Hello great video! I just wanted to ask what is a pareto line? And what does it signify?
Ah, the Pareto line represents the Pareto principle, where 80% of our opportunities come from 20% of the inputs. Once the cumulative percentage line goes over the Pareto line, all the opportunities to the left of it (the bars) are the 80% majority.
Do you have video for Vendor Delivery Performance in a Pareto chart
fire your editor for skipping at 9:15, you started with the bar upside down and ended with it on the right side after the cut
can someone explain the pareto line being 70%? why 70%?
Ah - there is no specific reason. Many people will use 80%. Sometimes I find that 80% is too much. The main idea is that a large amount of outcomes will come from a few inputs 🙂
How do I arrange it from the highest to the lowest
Sort the values
Too fast for me dude. But a nice looking template.
great, but i got lost @ 20% of the video, if you could explain this a little bit slower.
Option 4 should be 98% not 99% ???
Too Fast !!
SO many aesthetics made you forget a HOW TO TH-cam VIdeo is basically about how stuff is DONE! difficult for a person to even follow
Terrible explanation. Started well but decided to change focus. Why did you decide to lose traction. Should have continued on building the chart individually
too fast discussion
buneaaağmına