How to Make a Pareto Chart in Excel

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: www.etsy.com/listing/11998005...
👍 Ready made and ready to use.
Learn how to make a Pareto Chart in Excel, which is the best way to discover the best opportunities in your business. The Pareto Chart has three different data sets on two different axis, which you learn to set up.
Timestamps:
00:00 Intro
01:25 Getting started
02:14 Creating the data table
04:09 Making the percentages
05:24 The cumulative percentage line
06:17 The Pareto line
06:59 Creating the Pareto chart
09:15 Adding the chart in one go
09:45 Formatting the Pareto Chart
11:19 The Finished product
#Excel #ProjectManagement
More Excel and Project Management templates (playlist) here: • How to Create Excel an...

[@michaelbwbrenner]

This is great, with expert formatting advice. David is the Bob Ross of EXCEL!

[@kevindurham8980]

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.

[@MarcosAlvarezGuzman]

Fast, Efficient, excellent.

[@jasonhunter7143]

To say you are the best is an understatement

[@abdelrahmankasm3798]

Really amazing video with senior experience in Excel.... thanks a lot

[@ronaldnatalia1724]

Hi David good day to you. Thank you for this training. I finally found a learning channel for excel that what I need.

[@elizabete6327]

Thank You for Your help !!!

[@arpandoshi9878]

Excellent explanation 🙏.

[@user-wy3lr3bo4q]

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?

[@cristianlopezmusic]

Agreed. It was a bit too fast and maybe a bit more explanation would help.

[@bckzilla]

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.

[@Omar-kk5jp]

man you are awesome I just done it for my assignment,, thanks a lot

[@Daughterofjesuss]

Too fast teaching for beginners should've made it bit slow so beginners can follow along while they practically make

[@maureencharagu8279]

well explained. thanks

[@shrikantbadge3978]

Very helpful

[@tubethis777]

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

[@davidmclachlanproject]

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.

[@tubethis777]

@@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.

[@bsharmomani3871]

Thank you

[@shabanafzal9440]

Nicely explained

[@GianYawnYT]

bro what happen at 9:15

[@josephusman3998]

Exactly!

[@sheldon9623]

He's like the Bob Ross of Excel

[@emmanuelbasam1381]

Awesome @David! Is it possible to make some tutorials on CPI, SPI and other Project Management key Metrics? Thanks

[@andrewwooddell3874]

Great video. You like spreadsheets the way I do, I really missed my calling

[@harveynguyen6789]

Very good

[@StopWhining491]

Looks like a combo chart, which Excel includes in its chart choices.

[@corazonignacio3894]

Do you have video for Vendor Delivery Performance in a Pareto chart

[@wwillis2220]

David I’m looking for a Pareto chart for Inventory Coordinator do you feel you template will help?

[@jlopez327]

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?

[@jeellescas7938]

Hello great video! I just wanted to ask what is a pareto line? And what does it signify?

[@davidmclachlanproject]

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.

[@DingoSlinger]

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?

[@LouG77]

why not use the pareto chart in excel?

[@katg1264]

What does the 70% mean?

[@jacquelinepug5546]

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 :)

[@davidmclachlanproject]

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!

[@Pepperlizing18]

How do I arrange it from the highest to the lowest

[@StopWhining491]

Sort the values

[@20appel]

Option 4 should be 98% not 99% ???

[@steveowen5143]

Too fast for me dude. But a nice looking template.

[@Iam-yv7fq]

can someone explain the pareto line being 70%? why 70%?

[@davidmclachlanproject]

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 🙂

[@cyberdyers]

great, but i got lost @ 20% of the video, if you could explain this a little bit slower.

[@minecraftjoe7528]

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

[@kudratmallik4398]

Too Fast !!

[@GianYawnYT]

too fast discussion

[@user-iw9ls4lc2p]

SO many aesthetics made you forget a HOW TO KZbin VIdeo is basically about how stuff is DONE! difficult for a person to even follow

[@josephusman3998]

Terrible explanation. Started well but decided to change focus. Why did you decide to lose traction. Should have continued on building the chart individually

[@gogor8017]

buneaaağmına