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.
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.
The plot is run for each dimension.
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".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
By default the Amount metric will be plotted. You can choose the metric to plot, for instance "COGS".
The COGS metric will be plotted.
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.