Author: Oscar Cronquist Article last updated on September 29, 2018

A Pareto chart is often used in statistics to demonstrate how sample values are distributed across given ranges, the values are grouped in equal bins (ranges) and sorted in a descending order, based on the number of samples in each group.

A Pareto chart is a sorted histogram with an additional line describing how each group contributes to the total. Like the histogram, the Pareto chart automatically creates groups and counts the samples that match the range. The columns show the number of samples in that range.

How to build

  1. Select your data.
  2. Go to tab "Insert" on the ribbon.
  3. Click "Insert statistics chart" button.
  4. Click "Pareto chart" button.
  5. Double-click on the x-axis to open the task pane.
  6. Select "Bin width:" and type 5, you may have to try different values here depending on the data you have.

    • "By Category" allows you to use text values, Excel will count text strings and plot the chart based on the number of text strings.
    • Automatic is the default setting. The intervals are created evenly based on the minimum and maximum value.
    • "Bin width" allows you to specify the range you want to use.
    • Select "Number of bins" if you want to specify the number of intervals to use.
    • Select "Overflow bin" and "Underflow bin" to create an interval for all values above/below a threshold.