
An example of a Pareto Diagram and how to create it in SPC XL is shown below.
A computer manufacturer has maintained records of why people return computers. A subset of the data is shown below.
In SPC XL, select "SPC XL" - "Analysis Diagrams" - "Pareto Chart..." from Excel's menu bar.
The first step is to select the source data for the Pareto Chart.
The second step is to choose the options for the Pareto. You can change the sort order, bar type, gap width (the distance between bars), and the # of groups.
Finally, enter the desired chart and axis titles.
SPC XL creates the Pareto Chart.
SPC XL integrates directly within Microsoft Excel. After installation, you will have a new menu item on the Excel toolbar entitled "SPC XL".
All of the control charts in SPC XL can be updated without having to recreate the chart.
All of SPC XL's analysis results in a standard Excel workbook that can be shared with anyone who has Excel.