Skip to content

PARETO STACKED BAR

A Pareto stacked bar chart is a type of chart that shows the pareto ABC classes with a horizontal stacked bar. The chart is named for the Pareto principle, and its purpose is to highlight the most important among a set of factors comparing this along different metrics.

PLOT DETAIL

The plot is run twice,...

image-20210902124351490

...once for each period.

The bars are color coded by A,B,C class (A=up to 80%, B= 80 to 95%, C=95 to 100%, Loss= negative values).

In the example above, the top, A class, products represent 79.3% of the sales amount of 106.3M. In numerical terms we are talking of 33% of the 81 SKUs (27 different product references). These references represent 69.9% of the units sold and 92.5% of the margin.

image-20210902124427887

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-20210830155850870

OTHER OPTIONS

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

Additional options are available for selection.

image-20210902123233271

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

PLOT DIMENSION CHOICE

For instance in this case "Brand" is both the plotting dimension and the dimension on which we want to count unique values on.

image-20210902125103910

This means that the A-class brands that represent a bit less than 80% of revenues - we have chosen "Amount" as our ABC class ranking metric - represent also 68% of units and 82% of margins, and are 43% of the total number of Brands.

image-20210902125042238

If you do not want to count by Brand, but you want to know, for instance, how many SKUs are sold by each class of Brands you need to set the "unique items count column" to Product.

image-20210902125332837

This will return this chart. The A-class brands are selling 56% of the 81 SKUs.

image-20210902125406713

Note that if the "count" dimension and the "plot" dimension are not hierarchical, the total of the count column will probably be higher than the total of unique items. For example we change the plot dimension to Country we get a much higher total (614) because many items are sold in more than one Country.

image-20210902125729276

If we set back the count dimension to "Country" we see that 36% of the Countries bring 77% of the revenues, 74% of the volumes and 80% of the margins.

image-20210902130134015

PLOT BY ITEMS OF DIMENSION

Instead of aggregating the items of your dimension by ABC class, you can directly plot the items of your chosen class, ranked by your ranking metric.

image-20210902130558822

For instance, this chart is equivalent to the "by Brand" chart shown above, but details the specific brands. We learn that 73.8% of revenues is made up by the top three Brands, Magritte, Farer and Pelton.

image-20210902130853652

The chart will show up to 10 items separately. If the items of the dimension are more than 10, these will be automatically aggregated. You can choose to show less items and aggregate the rest.

image-20210905200718713

METRIC CHOICE

If you choose to plot more than one metric, the order of the metrics will dictate the order of the metrics in the plot.

image-20210812171240984

All items will be ranked on the first chosen metric, "amount" in this example.

image-20210830164401503

You can select as many metrics as you like.

image-20210830164432494

NEGATIVE VALUES

Negative margin values are plotted as negative values below the zero y axis if the margin metric is not the ranking metric. In the example below the products of theC revenue class are responsible for negative margins. These product SKUs represent 47% of the total number of SKUs. Their loss is equivalent to the profit of the B class SKUs.

image-20210830164513168

If the margin metric is chosen as the ranking metric, different view is shown.

The negative margin SKUs eat up about one forth of the total margin. They represent almost half the SKUs and about 20% of the sales.

image-20210830164542745

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-20210830164622203

CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

image-20210830164645711

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

image-20210830164714280

BLUE & GREEN PALETTE

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

image-20210830164735433

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

image-20210830164757509

POLO PALETTE

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

image-20210830164824441

HEATING UP PALETTE

This bright palette is great for complex charts.

image-20210830164852933

POWERBI DEFAULT PALETTE

A lively, colorful palette.

image-20210830164920469

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

image-20210830164946321

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-20210907122520737

Add your comment, one chart at a time.

image-20210907122958950

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

Your comment will appear above the chart title

image-20210907123052757

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

image-20210907123227261

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

image-20210907123342416

The downloaded image of the chart contains the comment.

image-20210907123418454