Build a Pareto chart

Paste your data and see which few causes make up most of the problem. Everything runs in your browser, so your data is never uploaded.

Your data

Paste from Excel or a CSV

Either two columns (category and count), or one column with a row for every occurrence — repeats are counted for you.

First row is column headings

Chart settings

Chart title

Count axis label

Cut-off %

Group after

Group after: keep this many categories and put the rest into "Other". Use 0 to show them all.

Scale count axis to the total, so both axes line up Show data labels

Result

Paste data on the left to build your chart.

How to read it: bars show each category's count, largest first. The line shows the running total as a percentage. Categories up to the cut-off line are the "vital few", where improvement effort is likely to have most effect.

Want to build your skills? Book QI training with the CITI Academy.