Pareto Chart Add-on

Modified on Wed, 02 Dec 2015 02:54 PM by — Categorized as: Uncategorized

Click to return to: Documentation | Dundas Dashboard Add-ons

Go to the Dundas Dashboard Add-ons page for instructions on downloading and installing this add-on.


The Pareto chart is named after Italian sociologist, economist and philosopher Vilfredo Federico Damaso Pareto. It contains both a bar chart and a line graph where individual values are represented in descending order by bars, and a cumulative percentage is represented by the line. It allows readers to quickly identify the most important of a number of factors, causes or defects. The percentage line can help to identify how much the top N factors contribute to the total up to each point.

A Pareto chart.

A Pareto chart.

A Pareto chart with two series and a legend.

A Pareto chart with two series and a legend.

General usage

The Pareto Chart add-on works like other charts:

  1. Add a Pareto Chart to your dashboard in the Dashboard Designer.
  2. Drop a KPI or dataset onto the Pareto Chart.

Each series of data added to the pareto chart will be stacked on top of the previous as a stacked bar chart. The cumulative percentage line is calculated using the total of each stack.

The cumulative percentage line is optional. To display only the bars or stacked bars in descending order, hide the cumulative percentage series:

  1. Find the Series property of the chart and click its ellipsis button.
  2. Select the Cumulative Percentage series on the left.
  3. Find the Visibility property and set it to Collapsed.

When to use Pareto charts

Pareto charts are typically used to prioritize competing or conflicting “problems,” so that resources are allocated to the most significant areas. In general, they can be used to determine which of several classifications have the most “count” or cost associated with them. For instance, the number of people using the various ATM's vs. each of the indoor teller locations, or the profit generated from each of twenty product lines. The important limitations are that the data must be in terms of either counts or costs. The data cannot be in terms that can't be added, such as percent yields or error rates.


There is an additional property on the Pareto chart:

ImageImageProperty Name [Script Name]TypeDescription
Auto-Adjust Y Axis [IsYAxisAutoAdjusted]boolDetermines if the scale of the quantity axis automatically adjusts to match up the heights of the quantities with the cumulative percentages. If False, the cumulative percentage line may overlap with the bars. The default is True.

Release history

Related topics

Click to return to: Documentation | Dundas Dashboard Add-ons