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

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

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

[@sabrinamcmichael1905]

This was well done and easy to follow. Thank you so much for sharing.

[@mrsmelaniecook]

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

[@studio33128]

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

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

[@Miss_Sir2]

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

[@damienbrowne3423]

Thanks Luca, That was great.

[@wolverngpinas]

Commented and Subscribed! Thankyou so much sir!

[@samahallaham9683]

Thank you. You are a life saviour

[@Kizihiza]

thank indeed for your supporting

[@lucabalestrieri]

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

[@Shubhamsingh-zq7gd]

Easy to understand tutorial. Kudos!! 👏

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

[@calebpilafas8397]

Very well done!

[@lucabalestrieri]

Thank you very much!

[@Smallfryfelicia]

Thanks for the tutorial! You truly made it easy.

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

[@TheCarola2008]

Thank you! Huge help for my essay!

[@AustinOSanders]

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

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

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

[@shraddhabaeet3793]

Helped a lot !!!!🙌

[@lucabalestrieri]

Great 👍

[@itsbumbleblue]

thank you so much for this! :)

[@ianmcnicholas634]

Appreciate the video , tx

[@M_B57]

Thank you 😃

[@lucabalestrieri]

Glad it helped.

[@dynamixproductions]

thanks for sharing, really helpful, highly appreciated👏

[@Holynpure-fz9nc]

thank you mate

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

[@BlkBornSeed]

Very nice work. Thank you.

[@antonioallen1763]

This was awesome! Thank you!

[@lucabalestrieri]

Glad I could help

[@dilshaniiresha9317]

Thanks a lot ❤️

[@lucabalestrieri]

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

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

[@ericchapman9579]

Right off the bat, I need more information. I have a list of raw data that I need to get into defect types by count. How did you get to step 1?

[@lucabalestrieri]

@@ericchapman9579 excel has a count function you can use. I’m sure there is a tutorial for the count function on KZbin. Good luck.

[@jadevonbeauty9409]

What is the difference between the total percentage and cumulative percentage ?

[@rajkrish9347]

tq so helpful

[@lucabalestrieri]

Happy to help

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

[@amanjismani6110]

Thanks for sharing

[@lucabalestrieri]

Anytime.

[@Sophiademongo]

The bar in the second series is too small for my cursor to recognize it so I cannot format the data series. Can you help me, please?? I do not know how to get around this issue and I am so frustrated. SOS.

[@retonwalford963]

This is awesome instruction 👍👍

[@pratish17]

Thanks buddy 😉

[@karthikeyanj8910]

Nice bro

[@IamOnlyaHumanafterall]

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

[@oanhluong7051]

Can you teach us how to do X and R chart

[@lucabalestrieri]

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

[@Magnate1992]

Thank you genius!

[@lucabalestrieri]

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

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

[@CatherineFifi]

Same!

[@fortunekowe9486]

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

[@s1a9f9i3]

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

[@miyawable]

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

[@yesayachristian]

Thank you

[@lucabalestrieri]

You’re very welcome.

[@lukeMCjohans]

i cant find select under data

[@hhh2569]

may i know this is what version of excel？

[@lucabalestrieri]

2016

[@anilahari992]

Thanku👍

[@reamarichelestopace2298]

Thank you.

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

[@faisalalqhtani8891]

Thanks a lot 🎉

[@allsmiles3281]

Thank you.

[@enampharma9484]

Thank you.