top of page
Writer's pictureDp

How To Create Pareto Chart In Excel || Pareto Analysis in Excel - 80/20 Rule or Pareto Principle

Updated: Jun 20, 2020

In this tutorial, let us learn about Pareto chart and how to create this in Excel.

Pareto chart is based on Pareto principle also known as 80:20 rule. this is basically used in project management.


According to this principle 80% of problems are caused because of 20% of issues or else

80% of results are because of 20% efforts that we put in. So in project management, we use this principle to solve 80% of the problems by targeting 20% of those issues.

So, let us now see how to create this Pareto chart in Excel for our further analysis.

This is my example data as shown here.


Here, I am showing different reasons and their respective occurrences.


Steps:


1. Arrange this data in the descending order of occurrences i.e column D


2. Calculate Cumulative %s of occurrences in column E


3. Apply the same formula in all cells

4. Select entire data range I,e C4:E13

5. Go to insert tab and click on 2D column cluster chart


6. Right click on any of the bars and select change series chart type.

7. In the dialog box, select combo in the left pane

8. For first series, maintain the chart as cluster

9. For 2nd series i.e cumulative % series, select the chart type as line and tick the checkbox to make it as secondary


10. Adjust the vertical axis to make the maximum value as 1

11. Now, draw two lines bisecting at 80% on your vertical axis and drop a vertical line to the x axis from the point


12. This will show that the bars to the left side of this point are 80%

13. You can color these bars with color so as to highlight the data for better presentation.


So friends this is how we create the Pareto chart in Excel.


Watch this video tutorial for better understanding:


If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you. You can write us at dptutorials15@gmail.com


***********************************************

★ My Online Tutorials ► https://www.dptutorials.com

LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources

Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2

Support the Channel via shopping: http://ift.tt/2jH38PR

Tools for youtube vlogging:

• Screen recorder: https://techsmith.pxf.io/2BMjA

• Harison Softbox Studio Lights: https://amzn.to/3caGbzg http://fkrt.it/ypCaRQNNNN

• Background Support Stand: https://amzn.to/3dbACSv http://fkrt.it/A3cCb_uuuN

• Acoustic Foam Background: https://amzn.to/3gzFtyC http://fkrt.it/ypsGdQNNNN

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

***********************************************

You Can Connect with Me at:

Follow:

0 comments

Recent Posts

See All

Comments


bottom of page