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

[@lucabalestrieri]

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

[@NahwiaMazrui]

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

[@mrsmelaniecook]

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

[@Miss_Sir2]

Straight to the point.. easy to follow. Thank you

[@studio33128]

Thank you so much. I'm studying lean six sigma...this really helped!

[@BJordanSounds]

This was perfectly demonstrated! thank you!

[@lucabalestrieri]

Glad it helped

[@supermariosworldtv4115]

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

[@HereForWisdom]

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

[@samahallaham9683]

Thank you. You are a life saviour

[@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!

[@clipsonclipsonclipsisthebest]

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

[@Shubhamsingh-zq7gd]

Easy to understand tutorial. Kudos!! 👏

[@Smallfryfelicia]

Thanks for the tutorial! You truly made it easy.

[@TheCarola2008]

Thank you! Huge help for my essay!

[@titan_reborned]

Not sure you gonna see this, you just got another subscriber

[@lucabalestrieri]

I see your comment! Thank you very much and welcome to the group. 👍

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

[@wolverngpinas]

Commented and Subscribed! Thankyou so much sir!

[@dynamixsoundsmusics3615]

thanks for sharing, really helpful, highly appreciated👏

[@bahoforever]

thank indeed for your supporting

[@lucabalestrieri]

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

[@calebpilafas8397]

Very well done!

[@lucabalestrieri]

Thank you very much!

[@faisalalqhtani8891]

Thanks a lot 🎉

[@itsbumbleblue]

thank you so much for this! :)

[@BlkBornSeed]

Very nice work. Thank you.

[@shraddhabaeet3793]

Helped a lot !!!!🙌

[@lucabalestrieri]

Great 👍

[@enampharma9484]

Thank you.

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

[@ianmcnicholas634]

Appreciate the video , tx

[@antonioallen1763]

This was awesome! Thank you!

[@lucabalestrieri]

Glad I could help

[@retonwalford963]

This is awesome instruction 👍👍

[@traiangle1]

Hello Luca...very helpful in making chart. Thanks. Could you pls let me know how to make pareto chart for efficiency where lower efficiency lines causing overall loss of efficiency of factory. So here smallest to largest need to be sorted.

[@M_B57]

Thank you
😃

[@lucabalestrieri]

Glad it helped.

[@Magnate1992]

Thank you genius!

[@lucabalestrieri]

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

[@pratish17]

Thanks buddy 😉

[@amanjismani6110]

Thanks for sharing

[@lucabalestrieri]

Anytime.

[@rajkrish9347]

tq so helpful

[@lucabalestrieri]

Happy to help

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

[@karthikeyanj8910]

Nice bro

[@yesayachristian]

Thank you

[@lucabalestrieri]

You’re very welcome.

[@IamOnlyaHumanafterall]

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

[@lamyaalhazzani3880]

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

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

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

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

[@anilahari992]

Thanku👍

[@s1a9f9i3]

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

[@oanhluong7051]

Can you teach us how to do X and R chart

[@lucabalestrieri]

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

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

[@ferdzmendez555]

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

[@hhh2569]

may i know this is what version of excel？

[@lucabalestrieri]

2016

[@Goonies-xh3qr]

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

[@alexadrianang8655]

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

[@lucabalestrieri]

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

[@dilshaniiresha9317]

Thanks a lot ❤️

[@lucabalestrieri]

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

[@allsmiles3281]

Thank you.

[@reamarichelestopace2298]

Thank you.