Skip to content

TWO MINUTE MARIMEKKO PLOT

In less than two minutes, you will build a Marimekko plot from scratch.

The Marimekko chart is often used by consultants, particularly Bain & Company, to illustrate the interaction between two dimensions. It is also a pain to draw without add-ins.

marimekko (16)

1 - GET DATA

We use Microsoft's Financial sample dataset you can download here. Open it in Excel. Select the columns with the metrics (revenues, units, cogs, columns E to L) and set their number format to "General". Delete the N, O and P columns. Your file should look like this. Save the file and exit Excel.

image-20210919211535216

2 - LOAD DATASET ON 'MPARANZA.COM APP

Open 'Mparanza.com, and click on "Open Beta".

Open the upload widget and load the file. The app should automatically map all the columns.

image-20210919211852311

3 - PLOT MEKKO

Set the 📊 Plot type widget to Marimekko.

image-20210919212156039

Hit the 🚀 Submit button. You should get your Marimekko plot.

marimekko (17)

How many "other" countries are there?

Open the expander below 📊 Plot type,and set the "Number of top" country widget to five.

image-20211213152016285

Oh there is also - ex-equo - France and Mexico.

marimekko (19)

By default, the app uses a grey, do-not-use-colors-for-decoration color palette. If you prefer a different color palette, choose it with the widget below.

image-20210919212946929

Hit the 🚀 Submit button.

marimekko (20)

Instead of absolute values, you can display percentages, either of the total, or of the total of each row.

marimekko (21)

You can select to plot a different column on the vertical (or on the horizontal) axis. Move the labels around if they overlap.

marimekko (23)

You can choose to plot a different metric.

marimekko (24)

Finally, if you like Barmekkos (the little sister of the Marimekko), just set the 📊 Plot type widget to "Bar mekko" and hit the 🚀 Submit button.

barmekko (1)

Back to top