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

Varying Pareto chart bar colors

Color bars to highlight the importance of the vital few.

You must have already completed either of the tasks:
  • Creating a Pareto chart
  • Creating comparative Pareto charts
  1. Activate the analysis report worksheet.
  2. On the Analyse-it ribbon tab, in the Pareto group, click Vary Colors.

    Each bar is varied in color using the color assigned to the categories of the variable in the dataset.

  3. To color the bars to highlight some other attribute such as importance:
    1. Select the Assign Colors check box.
    2. In the Categories grid, under the Color column alongside the category, in the drop-down list, select the color. If you do not assign a color, the bar is colored gray.
    3. Repeat step 3.b for each category.
  4. Click Recalculate.
Related tasks
Assigning colors/symbols to categories
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.