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?
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.
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?
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.
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.
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 - 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
Too fast teaching for beginners should've made it bit slow so beginners can follow along while they practically make
This is great, with expert formatting advice. David is the Bob Ross of EXCEL!
To say you are the best is an understatement
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.
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.
He's like the Bob Ross of Excel
Fast, Efficient, excellent.
Thank You for Your help !!!
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.
man you are awesome I just done it for my assignment,, thanks a lot
Excellent explanation 🙏.
Really amazing video with senior experience in Excel.... thanks a lot
Nicely explained
well explained. thanks
讲解的很专业
Hi David good day to you. Thank you for this training. I finally found a learning channel for excel that what I need.
Great video. You like spreadsheets the way I do, I really missed my calling
Very helpful
Thank you
Looks like a combo chart, which Excel includes in its chart choices.
Very good
bro what happen at 9:15
Exactly!
David I’m looking for a Pareto chart for Inventory Coordinator do you feel you template will help?
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?
Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks
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.
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?
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
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
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!
why not use the pareto chart in excel?
What does the 70% mean?
How do I arrange it from the highest to the lowest
Sort the values
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 🙂
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% ???
To much explanation. The concept is simple yet you complicate it
Too Fast !!
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
Man just wasted my my 12 minutes, it's not that long, you could have finished it in under 5 minutes by directly making a PRETO CHART