Skip to content

STACKED BAR

The plot shows repartition of a metric across two dimensions in absolute value or as % of total at a given point in time. It is inspired by the stacked bar chart IBCS template.

image-20211205123205406

PLOT DETAIL

The plot is run twice,...

stackedbar

...once for each period.

stackedbar (1)

Categories are sorted by decreasing total metric value with "other rank > x" on the bottom of the plot.

stackedbar (7)

If only one dimension is selected, the app with return a simple (not stacked) bar plot.

stackedbar (2)

SMALL MULTIPLES PLOT

To plot the items as small multiples, set the Plot Small multiples widget to True.

image-20220619151633905

and hit the Submit button. The items of the first selected dimension (in this case Product Category) will be plotted against the other selected dimension (in this case Country). If relevant, the average of each sub plot is shown.

stackedbar

By default the subplots will show the top items calculated at the global level, and therefore the items will be identical for each sub plot. You can change this with this widget

image-20220712204843990

Now each plot will show the top items of each specific sub plot.

stackedbar (4)

If the two dimensions are hierarchical (such as country and region in the example below) the items shows in each sub graph will be different.

stackedbar (5)

SAVING THE PLOT

To save the plot as a PNG file, hover the top right side on the chart. A menu will appear. Click on the camera icon.

image-20211205145610940

OTHER OPTIONS

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

Additional options are available for selection.

image-20211205145750942

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 at top of the bars.

image-20211205145850235

Bar value (and legend) labels that would not fit in the chart are dropped or shortened.

image-20211207161319664

Legend labels shown on the top are not shortened and always displayed even if they overlap. Blanks are replaced with line break html tags ("<"+"BR"+">") in longer labels. For instance, in the example below the Office Supplies label is written on two rows.

image-20211207161517668

The labels are editable and movable. You can delete a label, move a label around the chart, or delete a line break tag in a label.

image-20211207161606259

You can choose the dimensions you want to plot on the X and Y axes, and which metric to plot.

image-20211205150757481

By default, the seven top items in terms of total value are plotted on the vertical axis and three on the horizontal axis. The other items are aggregated together and plotted in light grey color.

image-20211207161655455

You can change the number of top items to plot for each axis.

NORMALIZED STACKED PLOT

Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.

stackedbar (2)

ADD COMPANY NAME TO PLOT

You can add the company name to the plot title, as preconized by the IBCS standard.

image-20211220124254441

The company name will appear in the title.

stackedbar (1)

NEGATIVE VALUES

Negative values - for instance negative margins - will be plotted correctly. However you might need to adjust the label positions by hand.

image-20211205151732806

In case of % stacked bar charts, negative values will also be correctly plotted, but it might be necessary to adjust the position of the labels.

image-20211205151945357

EDIT AND MOVE LABELS

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

image-20211205152249975

...you can write the legend labels on two rows (insert the HTML "br" tag written in capital letters, "BR") and adjust their position.

image-20211205152336374

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

Draw and edit your shapes.

image-20211205152526528

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 to the text box, one chart at a time.

image-20211205163632992

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

Your message will appear above the chart title

image-20211205163745577

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

image-20211205163920092

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

image-20211205163956934

The downloaded image of the chart contains the message. You can also annotate the chart with shapes.

image-20211205164032998

CHART TITLE

By default, 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 grey line by moving them around with the mouse.

stackedbar

CHOICE OF COLOR PALETTE

You can choose one of the 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.

image-20210621093612534

GREYSCALE PALETTE

Avoids decorative use of colors. Good for a limited number of items. Similar pallets are available in other colors (greens, blues, reds,...)

image-20211207162053683

image-20211205164153964

TABLEAU PALETTE

This elegant palette is both beautiful and functional.

image-20211205164558519

CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

image-20211205164342885

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

image-20211205164314452

BLUE & GREEN PALETTE

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

image-20211205164412467

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

image-20211205164439150

POLO PALETTE

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

image-20211205164504901

HEATING UP PALETTE

This bright palette is great for complex charts.

image-20211205164530809

POWERBI PALETTE

A lively, colorful palette.

image-20211205164631996

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

image-20211205164705538