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.

image-20210919210340678

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.

image-20210919212358782

The numbers in the top right corner are on top of each other. We might want to show "Midmarket" aggregated into "Other" to fix this.

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

image-20210919212657614

By default, the app uses the Tableau color palette. If you prefer a different color palette, choose it with the widget below.

image-20210919212946929

Hit the 🚀 Submit button.

image-20210919213027822

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

image-20210919213403648

You can select to plot a different column on the X (or on wthe Y) axis.

image-20210919213840886

You can choose to plot a different metric.

image-20210919214152975

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.

image-20210919225440836