Skip to content

MULTI-TIERED BAR PLOT

The multi-tier bar chart, inspired by this IBCS template, can be used to analyze the data structure of different dimensions.

image-20210907112432002

The first tier of this template compares different scenarios in a grouped bar chart. The second and third tiers show different absolute and relative variance charts.

PLOT DETAIL

The plot is run for the chosen metrics at the total level...

multi_tier_bar

multi_tier_bar (1)

..and, for each dimension, it is run for the chosen metric.

multi_tier_bar (4)

The most recent, Actual, value is show with in black. The less recent, or Plan, value, is shown with in grey or outlined white. Red is "bad" while green is "good."

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

OTHER OPTIONS

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

Additional options are available for selection.

image-20220412163659295

METRIC SELECTION

A metric will be plotted default. You change the metric to plot, for instance "COGS".

image-20220412163740325

The COGS metric will be plotted.

multi_tier_bar (10)

SMALLER ITEMS AGGREGATION

By default, the four top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.

You can change the number of top items.

multi_tier_bar (11)

EDIT AND MOVE LABELS

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

multi_tier_bar (12)

...we have moved and edited the title.

multi_tier_bar (13)

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

Draw and edit your shapes.

multi_tier_bar (14)

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

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

Your message will appear above the chart title. You can save the chart with the message and the annotations.

multi_tier_bar

In some cases the chart message might overlap with the chart title or otherwise appear in the wrong place.

image-20220407103935876

Simply adjust their position with the mouse.

multi_tier_bar (1)

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.

multi_tier_bar

Back to top