2️⃣ MINUTE⌛MARIMEKKO

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.

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.

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.

3 - PLOT MEKKO

Set the 📊 Plot type widget to Marimekko.

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

How many "other" countries are there?

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

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

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.

Hit the 🚀 Submit button.

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

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

You can choose to plot a different metric.

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.