Skip to content

MULTI-TIERED BAR PLOT

The multi-tier bar chart, inspired by this IBCS template, can by 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 each dimension.

multi_tier_bar (10)

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, click on the small circle to the right of the legend, and select "save as PNG".

image-20210628103043412

OTHER OPTIONS

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

Additional options are available for selection.

image-20210907110445283

METRIC SELECTION

By default the Amount metric will be plotted. You can choose the metric to plot, for instance "COGS".

image-20210628103305151

The COGS metric will be plotted.

multi_tier_bar (12)

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, and you can choose not to plot the value of the other aggregated items.

multi_tier_bar (13)

ENABLE PLOT COMMENTS

It is possible to add comments to the chart, in the style of the already mentioned IBCS template.

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

Add your comment, one chart at a time.

image-20210907111255306

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

Your comment will appear above the chart title

image-20210907111532312

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

image-20210907111742255

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

image-20210907111932749

The downloaded image of the chart contains the comment.

image-20210907112015727