Skip to content

PARETO PLOT

A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. The chart is named for the Pareto principle, and its purpose is to highlight the most important among a set of factors.

PLOT DETAIL

The plot is run twice,...

image-20210831152347122

...once for each period. The bars and the cumulative % line are color coded by A,B,C class (A=up to 80%, B= 80 to 95%, C=95 to 100%, Loss = negative values).

image-20210831152405969

SAVING THE PLOT

To save the plot as a PNG file, click on the small camera icon on the top right corner of the plot.

image-20210812170953851

OTHER OPTIONS

Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.

Additional options are available for selection.

image-20210917124144759

You can choose the dimension you want to plot Y axes, and which metrics to plot.

PLOT MULTIPLE METRICS

If you choose to plot more than one metric,

image-20210812171240984

all plots will be ranked on the first chosen metric, "amount" in this example.

image-20210831151453651

You can select as many metrics as you like.

image-20210831151656914

PLOT ABSOLUTE VALUES

You can choose to see the absolute values rather than the percentages.

image-20210831151609681

PLOT RANKINGS

You can plot rankings as labels.

image-20210831151746321

FILTER TOP OR BOTTOM 30 ITEMS

You can filter the plot to see only the top 30 items.

image-20210831151913932

You can also filter the plot to see the bottom 30 items.

image-20210916103251099

This can be useful to identify, for instance, the products that lose more money.

Imagine a situation like this, with many products, some with significant revenue (light green) losing money.

image-20210916103625165

To find the names of the 30 worse offenders, we want to see the 30 bottom products. They are slicing off 20% of our profits.

image-20210916103818814

It is probably better to plot them in absolute values.

image-20210916103924103

NEGATIVE VALUES

Negative margin values are plotted in red. For instance, you can plot a chart showing the positive margin contribution of the "good" items, and how this is partially or totally eaten up by the negative margin of the "bad" items.

image-20210831152002850

The cumulate total of all plotted metrics should always be equal to 100%.

image-20210825214746959

If the total margin is negative the total will converge to -100% rather than to 100%.

image-20210825214847284

CHOICE OF COLOR PALETTE

You can choose one of the nine available color palettes. Six are inspired by Mekko Graphics, the other are default Tableau and PowerBi palettes, and a palette inspired from the IBCS examples. Red color for negative values does not change across palettes.

image-20210621093612534

TABLEAU PALETTE

This elegant palette is both beautiful and functional.

image-20210812184622629

CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

image-20210812184710685

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

image-20210812184737510

BLUE & GREEN PALETTE

This contiguous palette creates a bi-chromatic chart in cool subdued hues.

image-20210812184834274

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

image-20210812184912664

POLO PALETTE

This subdued palette is good for charts requiring contrast between segments.

image-20210812185006964

HEATING UP PALETTE

This bright palette is great for complex charts.

image-20210812185115543

POWERBI DEFAULT PALETTE

A lively, colorful palette.

image-20210812185202020

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

image-20210812185233719

ENABLE PLOT COMMENTS

It is possible to add comments to the chart, in the style suggested by the IBCS standard.

image-20210907103349777

Enable comments by setting the "enable plot comments" widget to True.

image-20210908110046644

You can find the "enable plot comments" checkbox in the Run widget expander.

image-20210907110650891

Hit the Submit button.

image-20210907110800029

A text box will appear above each chart.

image-20210917114412847

Add your comment, one chart at a time.

image-20210917114604563

Once you have finished writing the comment for a chart, click on the 🚀 Submit.

Your comment will appear above the chart title

image-20210917114720356

Now write another comment on the text box of a different chart.

image-20210917114824829

Click submit. Your second comment appears above the second chart.

image-20210917115020581

The downloaded image of the chart contains the comment.

image-20210917115122133