Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Pareto analysis

Creating a Pareto chart

Plot a Pareto chart to identify the most frequently occurring quality-related problems.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Pareto, and then click Single Pareto Chart.
    The analysis task pane opens.
  3. In the Variable drop-down list, select the categorical variable.
  4. If the data are in frequency form, in the Frequency drop-down list, select the frequency count variable.
  5. In the Primary axis drop-down list, select:
    Option Description
    Count Show the frequency of occurrence or unit of measurement.
    Percent Show the percentage of the total frequency or a total of the unit of measurement.
  6. Optional: To force the primary and secondary axis so that 1 unit on the primary axis is equal to the percentage of the total on the secondary axis, select the Lock axes scales check box.
  7. Optional: To label the bars, select the Label bars check box.
  8. Optional: To label the line, select the Label cumulative line check box
  9. Click Calculate.
Related concepts
Pareto chart
Related tasks
Reordering Pareto chart bars
Merging Pareto chart categories
Varying Pareto chart bar colors
Related reference
Dataset layout
Available in Analyse-it Editions
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Pareto chart
  •  Creating a Pareto chart
  •  Creating comparative Pareto charts
  •  Merging Pareto chart categories
  •  Varying Pareto chart bar colors
  •  Reordering Pareto chart bars
  •  Sorting bars on comparative Pareto charts
  •  Study design
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.