Chart & Visualization Issues

How to Create an Excel Manufacturer Defect Analysis Pareto Chart

John WilsonJohn Wilson Nov 10, 2026 870 views

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.

How to Create an Excel Manufacturer Defect Analysis Pareto Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Select your source data

Highlight the range of cells that contain your defect categories and their frequency counts.

2
Navigate to the Insert tab

Locate and click on the 'Insert' tab in the main Excel ribbon at the top of the window.

3
Open the Statistic Chart options

In the 'Charts' group, click on the 'Insert Statistic Chart' icon (it looks like a blue histogram).

4
Select the Pareto chart

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.

Insert a Built-in Pareto Chart
Automatic Cumulative Line: The Pareto chart also automatically calculates and displays a cumulative percentage line, which is standard for defect analysis to identify the top issues.
Create advanced charts effortlessly

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. 1. Open your dataset: Launch WPS Spreadsheet and open the document containing your defect tracking data.
  2. 2. Highlight data range: Select the specific cells containing the defect names and their frequency numbers.
  3. 3. Insert the chart: Go to the 'Insert' tab on the top ribbon, click on the 'Chart' icon, and choose the 'Statistic' category.
  4. 4. Apply Pareto formatting: Select the Pareto layout to automatically apply descending sorting and the cumulative trendline to your data visualization.
Fully compatible with Microsoft Excel (.xlsx) formats and standard defect analysis templates.Insert complex statistical charts, including Pareto and Histograms, with just a few clicks.A free, lightweight, and highly efficient spreadsheet application with a familiar interface.Seamless cross-platform synchronization allows you to analyze your data anywhere.
microsoft office alternative - wps office

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.