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.
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.
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.
By default, the app uses the Tableau 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 column.
You can select to plot a different column on the X (or on wthe Y) axis.
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.