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.

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.

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

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.

OTHER OPTIONS

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

Additional options are available for selection.

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.

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

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.

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.

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

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.

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.

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.

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.

EDIT AND MOVE LABELS

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

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

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.

Draw and edit your shapes.

ADD PLOT MESSAGE

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

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

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

Your message will appear above the chart title

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

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

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

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.