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:
• Canon 200D Camera: https://amzn.to/3d7jDR4 http://fkrt.it/AMz75_uuuN
• Benro Tripod: https://amzn.to/3exQoax http://fkrt.it/An1lm_uuuN
• Microphone: https://amzn.to/3c5lEvS http://fkrt.it/A2RHz_uuuN
• Collar Microphone: https://amzn.to/2X8DWrS http://fkrt.it/yL8kdQNNNN
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: https://amzn.to/3extb87 http://fkrt.it/ypUD8QNNNN
• Zoom H1 Audio Recorder: https://amzn.to/2TNdHFj http://fkrt.it/ypb7WQNNNN
• Harison Softbox Studio Lights: https://amzn.to/3caGbzg http://fkrt.it/ypCaRQNNNN
• Chroma Key Green Screen: https://amzn.to/2M60mn4 http://fkrt.it/A3gnb_uuuN
• Background Support Stand: https://amzn.to/3dbACSv http://fkrt.it/A3cCb_uuuN
• Acoustic Foam Background: https://amzn.to/3gzFtyC http://fkrt.it/ypsGdQNNNN
• USB RGB LED Strip: https://amzn.to/36BpCLF http://fkrt.it/A3T_5_uuuN
• Wireless Mouse: https://amzn.to/2TPIrW7 http://fkrt.it/A3Bqz_uuuN
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:
YouTube: http://www.youtube.com/c/dptutorials
Twitter: https://twitter.com/dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Follow:
Comments