Skip to content

BAR MEKKO PLOT

The bar mekko plot is a variable width bar chart. A bar mekko chart is an alternative to a bar chart, for instance to show product profitability, with gross margin as the bar height and sales as the bar width.

PLOT DETAIL

The plot is run twice,...

barmekko (9)

...once for each period.

barmekko (10)

SAVING THE PLOT

To save the plot as a PNG file, click on the small camera icon on the top right corner of the plot.

image-20210531111628184

OTHER OPTIONS

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

Additional options are available for selection.

image-20210803073805106

You can choose the dimension you want to plot, and which metrics to plot on the X and on the Y axes.

You can choose on which axis metric to sort the chart.

For instance, you could plot Gross Margin in % on the Y axis and revenue Amount on the X axis: the area of the polygons will be proportional to the Gross Margin in value.

image-20210918143828184

Alternatively, you could plot Average Unit Price on the Y axis and Units on the X axis: the area of the polygons will be proportional to the revenue Amount.

image-20210918144431539

By default, the chart is sorted on the y axis metric.

image-20210913110854106

It is also possible to sort the chart on the horizontal axis metric.

image-20210913110936202

By default, the four top items in terms of total value are plotted on each axes, while the other items are aggregated together.

barmekko

You can change the number of top items to plot, and you can choose to plot or not to plot the value of the other aggregated items.

barmekko (1)

NEGATIVE VALUES

Negative values on the Y axis will be plotted as shown in the example below.

barmekko (2)

Since negative values on the X axis cannot be plotted in a mekko plot, the negative values will be dropped and an error message will be shown.

image-20210624091637328

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

TABLEAU PALETTE

This elegant palette is both beautiful and functional.

barmekko (3)CIRQUE PALETTE

This bright palette contains clusters with distinct color separations.

barmekko (4)

MODERN PALETTE

This fresh palette contains modern tones and stunning highlight colors.

barmekko (5)

BLUE & GREEN PALETTE

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

barmekko (6)

KHAKI & DENIM PALETTE

This subdued palette great for complex charts.

barmekko (7)

POLO PALETTE

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

barmekko (8)

HEATING UP PALETTE

This bright palette is great for complex charts.

barmekko (9)

POWERBI DEFAULT PALETTE

A lively, colorful palette.

barmekko (10)

IBCS PALETTE

This functional palette minimizes the risk of confusion between colors .

barmekko (1)

GREYSCALE PALETTE

Avoids decorative use of colors.

image-20211014103721747

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

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

image-20210907110650891

Hit the Submit button.

image-20210907110800029

A text box will appear above each chart.

image-20210917115347640

Add your message, one chart at a time.

image-20210917115451657

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

Your message will appear above the chart title

image-20210917115548479

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

image-20210917115632451

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

image-20210917115805350

The downloaded image of the chart contains the message.

image-20210917115836071