17.2.5 Creating Pareto Charts

Create-Pareto-Chart

The pareto chart is a special type of bar chart accompanied with a line graph. Typically, the vertical bars, whose heights reflect the frequency or impact of problems, are in descending order of significance and the line graph is ascending monotonously.

Pareto charts can be used to identify factors that have the greatest cumulative effect on the system. Thus, it is helpful in screening out the less significant factors in an analysis.

Creating Pareto Chart from the Binned Data

If you have already had binned data, you can create a pareto chart from it by using the Plot: 2D: Pareto: Pareto Chart - Binned Data menu command, or click the Pareto Chart - Binned Data button on the 2D Graphs toolbar. This will bring up the plot_paratobin dialog.

Creating Pareto Chart from the Raw Data

If you have raw data, you can create a pareto chart from it by using the Plot: 2D: Pareto: Pareto Chart - Raw Data menu command, or click the Pareto Chart - Raw Data button on the 2D Graphs toolbar. This will bring up the plot_paratoraw dialog.

Quick Example

The following example shows you how to create pareto chart from binned data and raw data, respectively.

To plot pareto chart from binned data:

1. Activate the worksheet that has the binned data.

   

2. Select Plot: 2D: Pareto: Pareto Chart - Binned Data from menu or click the Pareto Chart - Binned Data button on the 2D Graphs toolbar to open the Plot_paretobin dialog.
3. Select column Data for Data Input Range and the col(Count) for Count Input Range.

   

4. Click the OK button to plot the pareto graph. During the plotting of the pareto graph, a result sheet ParetoBin1 containing the statistic results will be created automatically.

   

To plot pareto chart from raw data:

1. Activate the worksheet that has the raw data.

   

2. Select Plot: 2D: Pareto: Pareto Chart - Raw Data from menu or click the Pareto Chart - Raw Data button on the 2D Graphs toolbar to open the Plot_paretoraw dialog.
3. Select column Raw Data for Input.

   

4. Click the OK button to plot the pareto graph. During the plotting of the pareto graph, a result sheet ParetoRaw1 containing the statistic results will be created automatically.