STACKED COLUMN PLOT
The plot shows the value of the metrics available in the dataset across periods in absolute value or as % of the total. It is inspired by the stacked column chart IBCS template.
The plot is run for all metrics at the total level...
..and, for each dimension, it is run for the chosen metric. It is possible to exclude some dimensions, that will not be plotted.
Categories are sorted by decreasing total amount value with "other rank > x" on top of the plot.
The column width changes based on the aggregation period. Greater for year...
....smaller for quarter...
...still smaller for month...
...smallest for week.
A summary slide is also generated that shows the break down of the chosen metric by up to six dimension columns.
Use the "choose dimension not to plot" widget...
to exclude metrics from the plot.
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.
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 on the left of the column. Columns will be wider if labels are integrated into the bars. If the chart has more than 10 columns this widget is disabled and only left legend labels are shown.
Bar value (and legend) labels that would not fit in the chart are dropped...
Legend labels shown on the left of the left-most column are always plotted with no shortening even if that means that they overlap. Blanks are replaced with line break html tags ("<"+"BR"+">") in longer labels. For instance, in the example below the Sports & Outdoors label is written on three rows.
The labels are editable and movable. You can delete a label, move a label on the right side of the chart, or delete a line break tag in a label.
MAX NUMBER OF TIME PERIODS
The app plots a maximum of 25 time periods, and a maximum of 6 data series, again following IBCS recommendations.
SHOW CAGR IN DATA COLUMN
You can choose to show the CAGR values.
If the widget is set to True, calculated CAGR values will be shown on the data column on the right of the plot. If the plot is in successive quarters, months or weeks, the CAGR metric will be compounded by quarter, month or week, and shown as CQGR, CMGR or CWGR.
All metrics present in the dataset are plotted at the total level. The "choose metric to plot" widget ...
....selects the metric to plot at the dimension / column level.
By default, the three top items in terms of total Amount are plotted, while the other items are aggregated together and plotted in light grey. You can change the number of top items.
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.
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.
Negative values - for instance negative margins, will be plotted correctly, however value and legend labels might miss placed...
and need to be adjusted by hand.
Same in the case of % stacked bar charts...
... that also might need labels to be adjusted by hand.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...you can write the arts & crafts label on two rows (insert the HTML "br" tag written in capital letters, "BR") and adjust their position.
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.
ENABLE PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Enable messages by setting the "enable plot messages" widget to True.
You can find the "enable plot messages" checkbox in the Run widget expander.
Hit the Submit button.
A text box will appear above each chart.
Add your message, 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.
CHOICE OF COLOR PALETTE
Avoids decorative use of colors. Good for a limited number of items. Similar pallets are available in other colors (greens, blues, reds,...)
This elegant palette is both beautiful and functional.
This bright palette contains clusters with distinct color separations.
This fresh palette contains modern tones and stunning highlight colors.
BLUE & GREEN PALETTE
This contiguous palette creates a bi-chromatic chart in cool subdued hues.
KHAKI & DENIM PALETTE
This subdued palette great for complex charts.
This subdued palette is good for charts requiring contrast between segments.
HEATING UP PALETTE
This bright palette is great for complex charts.
A lively, colorful palette.
This functional palette minimizes the risk of confusion between colors .