How to Create A Pareto Chart Like A Pro in Excel | Pareto Principle Example

Hello, in this video I am going to show you how an easy and fast way to make a perfect Pareto diagram in excel. This is a useful lean six sigma or project management tool used to demonstrate the 80/20 principle and analysis.
Check out my last video about creating a swimlane diagram in MS Visio
• Fast and Easy Way to C...
Useful Resources:
Software Used - amzn.to/2yt1FsQ
Book "Creating a Lean Culture" - amzn.to/3ctlfUu
Subscribe to my LinkedIn
/ luca-balestrieri
*Disclaimer: This video is NOT sponsored. Some product links are affiliate links. I may receive a commission at no extra charge to you for purchases made through these links. A portion of any profits from this channel will go to support the Gary Sinise Foundation.

[@lucabalestrieri]

Get LEAN SIX SIGMA certified here: www.udemy.com/course/lean-six-sigma-certification-for-the-manufacturing-industry/?referralCode=BD085068E0AB110DA57E

[@brentgarret2388]

Love the way you explain the whole process. I actually ended up using the Pareto Chart template I downloaded from someka. Thank you for the video.

[@nerizacruz2584]

Hey thanks for the tutorial! Among other videos I've watched, yours made the most sense!

[@user-my2hc3fe6o]

Bless you!! Followed your guidelines step by step and managed to submit my school assignment. 🎉

[@HereForWisdom]

Fantastic breakdown. AND you told how you explain it. Thank you 🤝

[@Hobohound]

Thank you! You saved my excel project in my data analytics course !

[@feliciabaker5213]

Thanks for the tutorial! You truly made it easy.

[@supermariosworldtv4115]

Thank you for the assistance/ just managed to complete my pareto chart for a university assignment

[@TheCarola2008]

Thank you! Huge help for my essay!

[@samahallaham9683]

Thank you. You are a life saviour

[@clipsonclipsonclipsisthebest]

Great tutorial. I will keep returning to your channel to learn more.

[@dynamixsoundsmusics3615]

thanks for sharing, really helpful, highly appreciated👏

[@BlkBornSeed]

Very nice work. Thank you.

[@retonwalford963]

This is awesome instruction 👍👍

[@itsbumbleblue]

thank you so much for this! :)

[@BJordanSounds]

This was perfectly demonstrated! thank you!

[@lucabalestrieri]

Glad it helped

[@305heat_]

hi, thank you. do you have an updated version for this tutorial ? Using the pareto chart within excel? Thank you explaining the math for the chart as well.

[@antonioallen1763]

This was awesome! Thank you!

[@lucabalestrieri]

Glad I could help

[@ianmcnicholas634]

Appreciate the video , tx

[@allsmiles3281]

Thank you.

[@sarahwaugh4999]

Luca, thank you so much for this extremely helpful tutorial video!

[@lucabalestrieri]

No problem. Let me know if you want to see any other related content.

[@christopherthomas794]

a trick : watch movies on flixzone. Been using them for watching loads of movies recently.

[@leightontanner1978]

@Christopher Thomas Yup, I have been using Flixzone for since december myself :)

[@gideonjonathan1984]

@Christopher Thomas yea, been watching on flixzone for years myself :)

[@bahoforever]

thank indeed for your supporting

[@lucabalestrieri]

No problem. Let me know what else you’d like to see

[@Rr77184]

Thank you , well explained, subscribed

[@lucabalestrieri]

Awesome. Welcome aboard. Let me know if there are any video topics you’d like to see in the future.

[@pratish17]

Thanks buddy 😉

[@calebpilafas8397]

Very well done!

[@lucabalestrieri]

Thank you very much!

[@shraddhabaeet3793]

Helped a lot !!!!🙌

[@lucabalestrieri]

Great 👍

[@anilahari992]

Thanku👍

[@Magnate1992]

Thank you genius!

[@lucabalestrieri]

I hope it was helpful, let me know if you need any guidance.

[@dilshaniiresha9317]

Thanks a lot ❤️

[@lucabalestrieri]

You're welcome 😊. Let me know if you’d like to see any other type of tutorials.

[@M_B57]

Thank you
😃

[@lucabalestrieri]

Glad it helped.

[@karthikeyanj8910]

Nice bro

[@amanjismani6110]

Thanks for sharing

[@lucabalestrieri]

Anytime.

[@lamyaalhazzani3880]

on what basis should I write the defect numbers and percentages?

[@yesayachristian]

Thank you

[@lucabalestrieri]

You’re very welcome.

[@YoursAkki81]

Excellent, but how do you arrive at the total defects ?

[@rajkrish9347]

tq so helpful

[@lucabalestrieri]

Happy to help

[@tamekamingtarh3396]

HELP PLEASE.... I dont have the option from 3:24 to 4:30 in my excel ( i am using online version in google chrome )...... thank you in advance

[@jacquelinepug5546]

Help! This tutorial was so helpful except around 4:22 when you turn cumulative percentage into a line. I can't seem to find any way do do this! Can you PLEASE advise?

[@tubethis777]

Hi JP, select the green bars in the graph, then go to the "Insert" menu (for charts) and click on "Line", then pick 2D line

[@s1a9f9i3]

On my chart the cumulative percentage appears on the left and the total defects on the right, how can I change them?

[@fortunekowe9486]

am using the new verion of excel when I change the chart type it removes the chart completely what do I do

[@miyawable]

How do i input dollar sign when i dont have it on my keyboard

[@lukeMCjohans]

i cant find select under data

[@emmanuelchibambo3367]

when i add the percentage its giving 99% where is the 100 coming from because 30+26=56
56+16=72 not 73? i am little bit lost there?

[@lucabalestrieri]

It could be a rounding issue. Try increasing the number of decimal places displayed by formatting tue cells to show more decimal places.

[@oanhluong7051]

Can you teach us how to do X and R chart

[@lucabalestrieri]

Will work on that video next week! Thanks for the suggestion.

[@TwilightEunoia]

how to remove the pareto line?

[@hhh2569]

may i know this is what version of excel？

[@lucabalestrieri]

2016

[@ferdzmendez555]

Line should be on top of the defect with 30% not on the middle

[@alexadrianang8655]

Great but 56% + 16% is 72% not 73% 😇

[@lucabalestrieri]

Thanks for your comment. Maybe it’s a rounding issue.

[@Goonies-xh3qr]

The x axis turned the part descriptors into numbers. Frustrating.

[@enampharma9484]

Thank you.

[@reamarichelestopace2298]

Thank you.