Skip to content

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.

image-20211202162915710

PLOT DETAIL

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

stackedcolumn (22)

stackedcolumn (23)

..and, for each dimension, it is run for the chosen metric. It is possible to exclude some dimensions, that will not be plotted.

image-20211121183109209

Categories are sorted by decreasing total amount value with "other rank > x" on top of the plot.

stackedcolumn (15)

The column width changes based on the aggregation period. Greater for year...

stackedcolumn (4)

....smaller for quarter...

stackedcolumn (3)

...still smaller for month...

stackedcolumn (2)

...smallest for week.

stackedcolumn (1)

SUMMARY PLOT

A summary slide is also generated that shows the break down of the chosen metric by up to six dimension columns.

stackedcolumn (24)

Use the "choose dimension not to plot" widget...

image-20211214133713123

to exclude metrics from the plot.

stackedcolumn

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

OTHER OPTIONS

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

Additional options are available for selection.

image-20211121183215890

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.

image-20211116150649000

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

stackedcolumn (1)

...or shortened.

stackedcolumn (2)

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.

stackedcolumn (16)

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.

stackedcolumn (17)

MAX NUMBER OF TIME PERIODS

image-20211116154035403

The app plots a maximum of 25 time periods, and a maximum of 6 data series, again following IBCS recommendations.

stackedcolumn (18)

SHOW CAGR IN DATA COLUMN

You can choose to show the CAGR values.

image-20211126101202145

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.

stackedcolumn (15)

All metrics present in the dataset are plotted at the total level. The "choose metric to plot" widget ...

image-20211118121303005

....selects the metric to plot at the dimension / column level.

stackedcolumn (2)

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.

stackedcolumn (3)

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.

stackedcolumn (4)

ADD COMPANY NAME TO PLOT

You can add the company name to the plot title, as preconized by the IBCS standard.

image-20211220124254441

The company name will appear in the title.

stackedcolumn (3)

NEGATIVE VALUES

Negative values - for instance negative margins, will be plotted correctly, however value and legend labels might miss placed...

stackedcolumn (7)

and need to be adjusted by hand.

stackedcolumn (9)

Same in the case of % stacked bar charts...

stackedcolumn (10)

... that also might need labels to be adjusted by hand.

stackedcolumn (11)

EDIT AND MOVE LABELS

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

stackedcolumn (4)

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

stackedcolumn (5)

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

Draw and edit your shapes.

stackedcolumn (6)

ENABLE PLOT MESSAGE

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

image-20210907103349777

Enable messages by setting the "enable plot messages" widget to True.

image-20211102112835101

You can find the "enable plot messages" checkbox in the Run widget expander.

image-20211112124202206

Hit the Submit button.

image-20210907110800029

A text box will appear above each chart.

image-20211214135725781

Add your message, one chart at a time.

image-20211214135814196

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

Your message will appear above the chart title

image-20211214140007557

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

image-20211214140100735

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

image-20211214140649635

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

image-20211214140747601

CHOICE OF COLOR PALETTE

You can choose one of the nine 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.

image-20210621093612534

GREYSCALE PALETTE

Avoids decorative use of colors. Good for a limited number of items. Similar pallets are available in other colors (greens, blues, reds,...)

stackedcolumn (15)

stackedcolumn (16)

TABLEAU PALETTE

This elegant palette is both beautiful and functional.

stackedcolumn (23)

CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

stackedcolumn (18)

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

stackedcolumn (17)

BLUE & GREEN PALETTE

This contiguous palette creates a bi-chromatic chart in cool subdued hues.

stackedcolumn (19)

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

stackedcolumn (20)

POLO PALETTE

This subdued palette is good for charts requiring contrast between segments.

stackedcolumn (21)

HEATING UP PALETTE

This bright palette is great for complex charts.

stackedcolumn (22)

POWERBI PALETTE

A lively, colorful palette.

stackedcolumn (24)

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

stackedcolumn (25)

Back to top