Member-only story
Start Using a “Mekko” Chart to Monitor Recurring Revenue
Better analytics, better decisions
A Mekko chart is used to visualize data across two dimensions by using a fixed height y-axis and variable width bars for the x-axis.
Aside from the asestheic pleasure of a completely filled box, Mekko charts allow data to be segmented in two directions adding an extra dimension to analysis.
In our previous article Three Insights from Tracking MRR, we explained the benefits of going beyond “MRR over time” by segmenting the data. Mekko charts take this to another level.
After a brief introduction to Mekko charts, we’ll discuss why it is useful for analyzing recurring revenue. Finally, we’ll show how to set up a Mekko chart in any spreadsheet software such as Excel or Google Sheets.
What is a Mekko Chart?
Also known as a mosaic plot, the chart’s name originates from the Marimekko print, a pattern introduced by a Finnish textiles company.
The defining qualities of a Mekko chart are it’s percentage-based y-axis and variable width x-axis. The end result is a chart where every stacked bar is the same height and each stacked bar has a varying width, which is proportional to the other bars.
