How to Create an Excel Manufacturer Defect Analysis Pareto Chart
Question details
The user wants to recreate the Excel Manufacturer Defect Analysis template and understand how the chart automatically sorts values in descending order from unsorted source data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a visual defect analysis report where the highest frequency errors are presented first, without manually sorting the raw data.
- Observed behavior
- The user seeks the correct chart type that displays unsorted category data in a sorted, descending layout.
Ensure your dataset is arranged with at least one column for category names (like defect types) and an adjacent column containing their corresponding numerical frequencies or counts.
Insert a Built-in Pareto Chart
Use Excel's built-in Statistic Chart feature to automatically generate a descending order chart from unsorted data without using complex formulas.
The chart used in the Manufacturer Defect Analysis template is called a Pareto chart. A Pareto chart is a specific type of histogram that contains both bars and a line graph. Individual values are represented in descending order by bars, and the cumulative total is represented by the line.
Because this sorting mechanism is built directly into the Pareto chart logic, it eliminates the need to apply 'Sort Largest to Smallest' on your raw data table.
Highlight the range of cells that contain your defect categories and their frequency counts.
Locate and click on the 'Insert' tab in the main Excel ribbon at the top of the window.
In the 'Charts' group, click on the 'Insert Statistic Chart' icon (it looks like a blue histogram).
Under the 'Histogram' category dropdown, select the second chart option, which is the Pareto chart. Excel will instantly generate the chart with bars sorted in descending order.

Easily Build Pareto Charts for Defect Analysis in WPS Office
WPS Spreadsheet features powerful built-in statistical charting tools, allowing you to instantly generate complex Pareto charts for defect analysis without the hassle of manual data sorting.
- 1. Open your dataset: Launch WPS Spreadsheet and open the document containing your defect tracking data.
- 2. Highlight data range: Select the specific cells containing the defect names and their frequency numbers.
- 3. Insert the chart: Go to the 'Insert' tab on the top ribbon, click on the 'Chart' icon, and choose the 'Statistic' category.
- 4. Apply Pareto formatting: Select the Pareto layout to automatically apply descending sorting and the cumulative trendline to your data visualization.

Frequently Asked Questions
Why are the bars in my chart not sorting automatically?
If your chart is not sorting automatically, you likely selected a standard Clustered Column chart instead of a Pareto chart. To fix this, right-click the chart, select 'Change Chart Type', and choose the Pareto option under Statistic Charts.
Can I remove the cumulative line from the Pareto chart?
While the cumulative line is standard for a Pareto chart, you can hide it by right-clicking the line, choosing 'Format Data Series', and setting the Line option to 'No line'.
What is the purpose of the 80/20 rule in this defect analysis chart?
The Pareto chart visualizes the Pareto Principle (the 80/20 rule), which states that roughly 80% of problems or defects come from 20% of the causes. The descending bars combined with the percentage line help managers quickly identify which few defects need immediate attention.
Do I need special add-ins to create a Pareto chart?
No, in modern spreadsheet software like Excel 2016 and later, as well as WPS Office, the Pareto chart is built directly into the standard charting features under 'Statistic Charts' and requires no additional add-ins.




