Skip to content

PARETO STACKED COLUMN

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,...

stackedpareto (2)

...once for each period.

stackedpareto (3)

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.

Alternatively you can calculate the ABC class by one dimension and use another dimension as a "counter".

stackedpareto (4)

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

OTHER OPTIONS

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

Additional options are available for selection.

image-20211126121657999

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

INTEGRATED LEGEND LABELS

The plot does not use external color legends. IBCS recommends that this information be displayed within the chart and that external legends be avoided.

You can choose whether to plot legend labels integrated in the bars and/or on the left of the column. Bar legend labels and value labels that would not fit in the chart are automatically shortened or dropped entirely.

image-20211116150649000

"Both" selection will show the labels on the column at left and in the bars. It is possible to edit and move around the labels at left by clicking on them.

stackedpareto (3)

"Left only" with not show legend labels in the bars.

stackedpareto (4)

"Inside bars only" will show the legend labels only inside the bars, if they fit.

stackedpareto (5)

PLOT DIMENSION CHOICE

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

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.

stackedpareto (6)

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 "Plot" widget to "items" and the "unique items count column" to Product.

image-20210902125332837

This will return this chart. The three top A-class brands are selling 74% of sales with 56% of the 81 SKUs.

stackedpareto

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 (615) because many items are sold in more than one Country.

stackedpareto (1)

If we set Plot to "ABC classes" and 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.

stackedpareto (2)

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.

stackedpareto (6)

The can also show the average value by item for each aggregation. In this example the average revenue by product for each brand. If the labels overlap, you can move them with the mouse or delete them.

stackedpareto (7)

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.

stackedpareto (8)

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.

stackedpareto (7)

You can select as many metrics as you like and you can move the A, B, C labels around with your mouse.

stackedpareto (6)

SHOW METRICS IN DATA COLUMN

You can plot calculated metrics on the data column at left. The drop down menu will show the calculated metrics that are compatible with the metrics you have chosen to plot with the "choose metrics to plot" widget. For instance average price will not be shown unless you have chosen to plot both Amount and Units.

image-20211126101646332

The chart will plot with the calculated metrics in the data column on the right. You can move the values around with the mouse and annotate them with lines and shapes.

stackedpareto (4)
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 the B and C revenues class are responsible for negative margins. These products SKUs represent 56% of the total number of SKUs.

stackedpareto (5)

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

The negative margin SKUs eats up part of the margin. They represent 20% of the SKUs and about 7% of the sales.

stackedpareto (3)

EDIT AND MOVE LABELS

You can edit and move around plot titles and labels. In this chart...

image-20211126122754059

...if a label is too long you can write it on two rows (insert the HTML "br" tag written in capital letters, "BR") and adjust its position.

image-20211126123025231

ANNOTATE CHARTS

It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.

Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.

image-20211126123122251

Draw and edit your shapes.

image-20211126123255857

ADD PLOT MESSAGE

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

image-20210907103349777

Add your message, one chart at a time, in the text box.

image-20210907122958950

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

Your message will appear above the chart title

image-20210907123052757

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

image-20210907123227261

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

image-20210907123342416

The downloaded image of the chart contains the message.

image-20210907123418454

CHART TITLE

The chart title is set on three lines: the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").

You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.

stackedpareto (2)

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

GREYSCALE PALETTE

Avoids decorative use of colors. Can display up to 5 different tones. Similar pallets are available in other colors (greens, blues, reds,...)

stackedpareto (14)

stackedpareto (15)

TABLEAU PALETTE

This elegant palette is both beautiful and functional.

stackedpareto (22)

CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

stackedpareto (17)

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

stackedpareto (16)

BLUE & GREEN PALETTE

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

stackedpareto (18)

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

stackedpareto (19)

POLO PALETTE

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

stackedpareto (20)

HEATING UP PALETTE

This bright palette is great for complex charts.

stackedpareto (21)

POWERBI DEFAULT PALETTE

A lively, colorful palette.

stackedpareto (23)

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

stackedpareto (24)