Тёмный

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

Luca Balestrieri
Подписаться 2 тыс.
Просмотров 289 тыс.
50% 1

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.

Хобби

Опубликовано:

 

7 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 74   
@lucabalestrieri
@lucabalestrieri 5 месяцев назад
Get LEAN SIX SIGMA certified here: www.udemy.com/course/lean-six-sigma-certification-for-the-manufacturing-industry/?referralCode=BD085068E0AB110DA57E
@nerizacruz2584
@nerizacruz2584 3 года назад
Hey thanks for the tutorial! Among other videos I've watched, yours made the most sense!
@brentgarret2388
@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.
@Smallfryfelicia
@Smallfryfelicia 3 года назад
Thanks for the tutorial! You truly made it easy.
@HereForWisdom
@HereForWisdom 2 года назад
Fantastic breakdown. AND you told how you explain it. Thank you 🤝
@user-my2hc3fe6o
@user-my2hc3fe6o 4 месяца назад
Bless you!! Followed your guidelines step by step and managed to submit my school assignment. 🎉
@mrsmelaniecook
@mrsmelaniecook Год назад
Thank you! You saved my excel project in my data analytics course !
@clipsonclipsonclipsisthebest
@clipsonclipsonclipsisthebest 2 года назад
Great tutorial. I will keep returning to your channel to learn more.
@supermariosworldtv4115
@supermariosworldtv4115 Год назад
Thank you for the assistance/ just managed to complete my pareto chart for a university assignment
@wolverngpinas
@wolverngpinas 10 дней назад
Commented and Subscribed! Thankyou so much sir!
@TheCarola2008
@TheCarola2008 Год назад
Thank you! Huge help for my essay!
@dynamixsoundsmusics3615
@dynamixsoundsmusics3615 Год назад
thanks for sharing, really helpful, highly appreciated👏
@samahallaham9683
@samahallaham9683 Год назад
Thank you. You are a life saviour
@BlkBornSeed
@BlkBornSeed 2 года назад
Very nice work. Thank you.
@BJordanSounds
@BJordanSounds 10 месяцев назад
This was perfectly demonstrated! thank you!
@lucabalestrieri
@lucabalestrieri 10 месяцев назад
Glad it helped
@retonwalford963
@retonwalford963 3 года назад
This is awesome instruction 👍👍
@sarahwaugh4999
@sarahwaugh4999 3 года назад
Luca, thank you so much for this extremely helpful tutorial video!
@lucabalestrieri
@lucabalestrieri 3 года назад
No problem. Let me know if you want to see any other related content.
@christopherthomas794
@christopherthomas794 3 года назад
a trick : watch movies on flixzone. Been using them for watching loads of movies recently.
@leightontanner1978
@leightontanner1978 3 года назад
@Christopher Thomas Yup, I have been using Flixzone for since december myself :)
@gideonjonathan1984
@gideonjonathan1984 3 года назад
@Christopher Thomas yea, been watching on flixzone for years myself :)
@antonioallen1763
@antonioallen1763 2 года назад
This was awesome! Thank you!
@lucabalestrieri
@lucabalestrieri 2 года назад
Glad I could help
@Rr77184
@Rr77184 2 года назад
Thank you , well explained, subscribed
@lucabalestrieri
@lucabalestrieri 2 года назад
Awesome. Welcome aboard. Let me know if there are any video topics you’d like to see in the future.
@itsbumbleblue
@itsbumbleblue Год назад
thank you so much for this! :)
@305heat_
@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.
@allsmiles3281
@allsmiles3281 2 года назад
Thank you.
@faisalalqhtani8891
@faisalalqhtani8891 19 дней назад
Thanks a lot 🎉
@Magnate1992
@Magnate1992 3 года назад
Thank you genius!
@lucabalestrieri
@lucabalestrieri 3 года назад
I hope it was helpful, let me know if you need any guidance.
@shraddhabaeet3793
@shraddhabaeet3793 Год назад
Helped a lot !!!!🙌
@lucabalestrieri
@lucabalestrieri Год назад
Great 👍
@pratish17
@pratish17 2 года назад
Thanks buddy 😉
@ianmcnicholas634
@ianmcnicholas634 Год назад
Appreciate the video , tx
@calebpilafas8397
@calebpilafas8397 6 месяцев назад
Very well done!
@lucabalestrieri
@lucabalestrieri 6 месяцев назад
Thank you very much!
@anilahari992
@anilahari992 3 года назад
Thanku👍
@bahoforever
@bahoforever 3 года назад
thank indeed for your supporting
@lucabalestrieri
@lucabalestrieri 3 года назад
No problem. Let me know what else you’d like to see
@amanjismani6110
@amanjismani6110 2 года назад
Thanks for sharing
@lucabalestrieri
@lucabalestrieri 2 года назад
Anytime.
@dilshaniiresha9317
@dilshaniiresha9317 Год назад
Thanks a lot ❤️
@lucabalestrieri
@lucabalestrieri Год назад
You're welcome 😊. Let me know if you’d like to see any other type of tutorials.
@karthikeyanj8910
@karthikeyanj8910 Год назад
Nice bro
@yesayachristian
@yesayachristian 3 года назад
Thank you
@lucabalestrieri
@lucabalestrieri 3 года назад
You’re very welcome.
@M_B57
@M_B57 10 месяцев назад
Thank you 😃
@lucabalestrieri
@lucabalestrieri 10 месяцев назад
Glad it helped.
@IamOnlyaHumanafterall
@IamOnlyaHumanafterall 2 года назад
Excellent, but how do you arrive at the total defects ?
@lamyaalhazzani3880
@lamyaalhazzani3880 4 месяца назад
on what basis should I write the defect numbers and percentages?
@tamekamingtarh3396
@tamekamingtarh3396 3 года назад
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
@rajkrish9347
@rajkrish9347 Год назад
tq so helpful
@lucabalestrieri
@lucabalestrieri Год назад
Happy to help
@fortunekowe9486
@fortunekowe9486 Год назад
am using the new verion of excel when I change the chart type it removes the chart completely what do I do
@s1a9f9i3
@s1a9f9i3 7 месяцев назад
On my chart the cumulative percentage appears on the left and the total defects on the right, how can I change them?
@jacquelinepug5546
@jacquelinepug5546 2 года назад
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
@tubethis777 2 года назад
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
@miyawable
@miyawable 10 месяцев назад
How do i input dollar sign when i dont have it on my keyboard
@emmanuelchibambo3367
@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
@lucabalestrieri Год назад
It could be a rounding issue. Try increasing the number of decimal places displayed by formatting tue cells to show more decimal places.
@lukeMCjohans
@lukeMCjohans 3 месяца назад
i cant find select under data
@oanhluong7051
@oanhluong7051 Год назад
Can you teach us how to do X and R chart
@lucabalestrieri
@lucabalestrieri Год назад
Will work on that video next week! Thanks for the suggestion.
@hhh2569
@hhh2569 2 года назад
may i know this is what version of excel?
@lucabalestrieri
@lucabalestrieri 2 года назад
2016
@ferdzmendez555
@ferdzmendez555 3 года назад
Line should be on top of the defect with 30% not on the middle
@Goonies-xh3qr
@Goonies-xh3qr 6 месяцев назад
The x axis turned the part descriptors into numbers. Frustrating.
@alexadrianang8655
@alexadrianang8655 2 года назад
Great but 56% + 16% is 72% not 73% 😇
@lucabalestrieri
@lucabalestrieri 2 года назад
Thanks for your comment. Maybe it’s a rounding issue.
@enampharma9484
@enampharma9484 6 месяцев назад
Thank you.
@reamarichelestopace2298
@reamarichelestopace2298 3 года назад
Thank you.
Далее
Китайка Шрек поймал Зайца😂😆
00:20
Create a Pareto Chart with a Target Line
13:03
Просмотров 89 тыс.
How to Make a Pareto Chart in MS Excel
7:58
Просмотров 23 тыс.
Fishbone Diagram Explained with Example
7:07
Просмотров 369 тыс.
Whiteboard: Pareto Analysis
7:01
Просмотров 285 тыс.
How to use a Pareto chart
3:41
Просмотров 188 тыс.