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