How to create a Pareto Chart in Excel - 80/20 Rule or Pareto Principle

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: bit.ly/3w8yclD
Join my full Power BI course: bit.ly/3RtTFwm
In this Video Tutorial I'll show you how to make a Pareto Chart in Excel - 80/20 Rule or Pareto Principle. A Pareto chart combines a column chart and a line graph. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes.
🔥 Subscribe to my Channel ► bit.ly/1KWfq14
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
💎Check Out My Udemy Online Courses ►►►►►►►►►►
📌Excel Dashboards and Data Analysis Masterclass ► bit.ly/35lO8OK
📌Excel Macros & Excel VBA Programming for Beginners ► bit.ly/2D3Ipkw
📌Excel Power Query, Power Pivot, Power Map & DAX Masterclass ► bit.ly/2qwa2jB
📌Excel Shortcuts, Hacks & Tricks: 100+ Tips for Excel 2016 ► bit.ly/2pEMlW8
📌Microsoft Excel Charts, Graphs and Data Visualization ► bit.ly/2qyosQr
📌Python for Beginners: Learn Python in One Day ► bit.ly/2s1nUTy
📌Complete Gmail Course ► bit.ly/2QCaUxQ
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🚩 Connect with me on social:
Facebook ► / mellontraining
My Blog ► www.mellontraining.com
My Online Excel Courses ► www.udemy.com/u/andrewex
Twitter ► / mellontraining
Linkedin ► gr.linkedin.com/in/andreasexadaktylos
KZbin channel ► / mellontraining
#excel #exceldashboards #exceltutorial

[@mellontrainingtutorials]

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: bit.ly/3w8yclD

[@ahn1772]

Simpel step by step tutorial. Keep up doing what you doing. Because you're doing great!

[@mellontrainingtutorials]

Thanks Arya Hashemi-Nasab I appreciate it!

[@godeepaksingh]

Brilliant. Simple and easy explanation, thank you !

[@mellontrainingtutorials]

Thank you very much for your kind words!

[@aestheticman2662]

You made the concept clear and easily understandable...Thank you!

[@mellontrainingtutorials]

Thank you Aesthetic Man for your kind words!

[@sechinah108]

Thank you. Clear, concise, easy to understand and follow.

[@mellontrainingtutorials]

Thanks sechinah108 I appreciate it!

[@petermaina1784]

Awesome description. I spent an hour looking for the Pareto graph. Cool video and ACCENT too. Lol

[@mellontrainingtutorials]

Thank you very much Peter for your kind words!

[@user-ns9kv9ni8b]

Thanks, finally it’s work👍👍👍👍 Expiation in google step by step didn’t work. Some formulas, some steps Here I did everything fast. Just show the name on chart for it’s be very very clear. Because it’s not recommended this type of chart for me.

[@naveengoyal7177]

Thanks ..there is always something new to learn from your videos

[@mellontrainingtutorials]

Glad you liked it Naveen!

[@martinhodge394]

Thank you!

[@someshbajpai6129]

Excellent ! thank you

[@courtneydebian]

Very Nice explanation! I had to check this out how to make it for my job. Thank you so much for posting.

[@mellontrainingtutorials]

Thank you!

[@MrEkaito]

This is very easy to understand. Very clear explanation. Thank you.

[@mellontrainingtutorials]

Glad it was helpful!

[@Mohammed-bd7ql]

Thank you good sir, this actually helped me with graphing the three axis, couldn't find a good dedicated video on that lol.

[@mellontrainingtutorials]

Glad it helped!

[@auroraautumn8764]

Thank you for sharing. It is better to see than to read it.

[@mellontrainingtutorials]

You are welcome!

[@adityakommu121]

Awesome contribution. Thank you

[@mellontrainingtutorials]

You are welcome!

[@wateri4]

very helpful and straight to point , thank you

[@mellontrainingtutorials]

Thank you wateri4 for your kind words!

[@xmc91.68]

You're a life saver thank you so much!

[@mellontrainingtutorials]

Thank you Xyrose Caya for your kind words!

[@mouthymimesproductions9985]

Excellent demonstration! Love it!

[@mellontrainingtutorials]

Glad you liked it!

[@josephbrowne5197]

Thanks a lot for sharing your knowledge!

[@mellontrainingtutorials]

My pleasure!

[@allenlundy5374]

How do I highlight different columns

[@evaid4436]

Perfect explanation thank you so much!

[@mellontrainingtutorials]

Glad it was helpful!

[@michalisdimitriadis6704]

ELLHNAAAS KAI PAIXTARAAAAAS .tromerh k suntomh douleia. really helpful 10/10 !

[@mellontrainingtutorials]

Se efxaristo poly!!

[@darylsmith9318]

Great video, helped a ton

[@mellontrainingtutorials]

Thank you!

[@MrVulcanator]

Thank you, this was very helpful.

[@mellontrainingtutorials]

Glad it was helpful!

[@360eees4]

Great from where we can get this work sheet you explained in this video☺

[@hemantgurung5575]

In the end, you inferred that the first 3 item categories (refreshments, spirits and mineral water) represent 80% or 8% of sales. Is there a calculation to show the inference? I was just slightly confused about how you calculated it. cheers.

[@diegovegafrances]

Nice! simple but useful

[@mellontrainingtutorials]

Thank you DVega VF for your kind words!

[@luisorozco8301]

THANK YOU!

[@mellontrainingtutorials]

You are very welcome Luis Orozco!

[@hahgmty42]

Excellent video, thank you very much

[@mellontrainingtutorials]

Glad you liked it!

[@azizsaif2615]

Loved it :) thank you

[@mellontrainingtutorials]

Thanks Aziz Saif I appreciate it!

[@johnareyes8938]

Thank you! You save me at my finals.

[@mellontrainingtutorials]

Happy to help!

[@casparvonvos2555]

Thank you

[@mellontrainingtutorials]

Thanks Caspar Von Voś I appreciate it!

[@lindarobinson2465]

Thank you so much! Well explained.

[@mellontrainingtutorials]

Thank you Linda Robinson for your kind words!

[@logen83]

Thank you brother

[@mellontrainingtutorials]

You are very welcome Logendra S!

[@rclavijo03]

This is a CLUSTERED COLUMN - LINE ON SECONDARY AXIS. And Pareto?

[@karamsingh1405]

Thank u so much dear sir

[@mellontrainingtutorials]

All the best

[@pinkfrosting0]

So cute!

[@mellontrainingtutorials]

Thank you pinkfrosting0 for your kind words!

[@gritfinance2643]

Thank you señor

[@mellontrainingtutorials]

So nice of you

[@bobschripsema1605]

bosss thankss

[@mellontrainingtutorials]

🤝

[@kanyewest132]

The lesson was very helpful Thank youAndrewSan Jose, California USA

[@mellontrainingtutorials]

You are very welcome!

[@alamshah7303]

Great

[@mellontrainingtutorials]

Thanks Alam Shah I appreciate it!

[@namratachummun4310]

Concise and precise video. It proved to be very helpful . Keep up the good job:.>))

[@mellontrainingtutorials]

Thanks a lot!

[@MrMosoani]

What's the importance of cumulative entries?

[@rowanlewis1780]

Good video

[@mellontrainingtutorials]

Thanks Rowan Lewis I appreciate it!

[@iangoh1099]

Mate, the first 3 columns, not sure if i heard you right. Represent 8 or 80% of the total sales?

[@mellontrainingtutorials]

80% of the total sales

[@jennifersanchez3589]

How did you highlight two different columns but everything was greaaaat

[@mellontrainingtutorials]

Thanks Jennifer Smith I appreciate it!

[@ootwpublishingmedia7894]

press and hold control (CTRL) and the continue highlighting

[@sultansami6311]

I couldnt do the step when press f4 it shows me a saving page how can I fix that?

[@puneetsharma2522]

Very short and simple 👌

[@mellontrainingtutorials]

Thanks Puneet Sharma I appreciate it!

[@syukrisaid6062]

sorry , got one question. what is the necessity of creating the cumulative column?

[@sankyeat]

your not working out each individual item category as a percentage. You are working out the percentage of the cumulative sales. Thats why you need it.

[@BLACKRED._]

how to hightlight the table like that? I mean, highlight data table A,B then D...without C data. Mine, just can select all data to make a chart, then need to deleted the graph series that I don't want.

[@BLACKRED._]

Is there any keyword that we need to press for highlight?

[@johnselimas614]

Are you Greek? Your accent sounds 100% Greek! Thanks for the video!

[@mellontrainingtutorials]

Yes I am!

[@thejaxdarkknight]

Hit control F4 and deleted everything I had… shambles

[@matthewpagano451]

how do they represent 80% if 33% +63% +79%=175% I am confused by how they represent 80% if they all add up to over 80%

[@mellontrainingtutorials]

Hello Matthew. You don't sum the values. Each one percentage value is separate and represent the cumulative sales of the items

[@kosatsalecacity]

Ελληνας είσαι φίλε?

[@mellontrainingtutorials]

Ναι, Έλληνας! Σε ευχαριστώ που παρακολούθησες το video!

[@yuuskee3]

Thank you!

[@mellontrainingtutorials]

You're welcome!