keisoku

Pareto Chart Maker

Just paste your "label,value" data to instantly build a Pareto chart: bars sorted from largest to smallest with a cumulative-share line on top. It also shows a share/cumulative table and an 80% line so the few items that matter most stand out at a glance.

Input

Item data (one "label,value" per line; separate items with line breaks)

Items detected: 6 (rows with unreadable or negative values are excluded)

Result

Vital few: items covering 80% of the total

3items

The top 3 items (out of 6) bring the cumulative share to 80%.

Total

114

Item count

6 items

Top item "Scratches"

45.6%

Pareto chart (bars: value / line: cumulative share)

0204060801000%20%40%60%80%100%80%45.6%70.2%83.3%91.2%96.5%100.0%Scratc…StainsWrong …Deform…Foreig…OtherValueCumulative (%)

Value per item (bars, left axis)

Cumulative share (line, right axis)

80% line

Breakdown by item

RankItemValueShareCumulative
1Scratches5245.6%45.6%
2Stains2824.6%70.2%
3Wrong size1513.2%83.3%
4Deformation97.9%91.2%
5Foreign matter65.3%96.5%
6Other43.5%100.0%
Total114100.0%—

How it works

  • Enter item names and values in "label,value" format, one per line (e.g. Scratches,52). Separate items with line breaks; commas, full-width commas, and tabs all work as delimiters.
  • Rows whose value can't be read as a number, and rows with negative values, are excluded automatically. If you omit the label, sequential names like "Item 1" and "Item 2" are assigned.
  • Your data is sorted from largest to smallest value and shown as a bar chart (left axis: each item's value) overlaid with a cumulative-share line (right axis: percentage).
  • Share is "this item's value ÷ overall total", and cumulative share is the running total of shares from largest to smallest. The top items that reach 80% cumulative share are your priority targets (the vital few).
  • The orange dashed line marks the 80% cumulative-share level. Focusing on the items up to where the line crosses it lets you improve the bulk of the whole efficiently.
  • Useful whenever you want to decide where to focus: QC defect-cause analysis, breaking down sales or complaint counts, ABC inventory analysis, and more.