Stop trying to make your spreadsheets easy to read. Ready to Take the Next Step and Up Your Excel and Data Analysis Skills? The pareto chart also automatically summarizes the defects with lower quantities into an 'Other' category to help keep the chart easy to read. If we focus on just this category, we will be addressing over 1/4 of the defects. QI Macros Pareto chart tells us that TH Void accounted for 16 of the defects which was 25.8% of the total. QI Macros will do all of the math and draw the chart for you. Just select your data, click on the QI Macros menu on your Excel tool-bar and select Pareto Chart. It's hard to create a Pareto Chart in Excel, but its easy using QI Macros add-in for Excel. If you look at the chart above: Is there a problem? What is it? What action should you take?Ī much better chart to analyze this kind of data is the Pareto Chart.

Pie charts are popular charts, but if you have too many categories they can become difficult to read. Consider a Pareto Chart for More Advanced Analysis There are several formats to choose from.Īfter you have created the chart you can add labels for each category. To create a Pie chart in Excel, select your data, then click on the Insert tab, then Pie. Free Agile Lean Six Sigma Trainer Training.Animated Lean Six Sigma Video Tutorials.

How do you make a pie chart in excel