Mekko Charts: What, Why & How to Build in PowerPoint

What is a Mekko chart?

A Mekko chart (also known as a Marimekko chart) is a two-dimensional stacked chart with varying column widths.

The easiest way to imagine a Mekko chart is to think of a column chart with no gaps between the columns and variable column widths. Each column can be a standalone or a stacked column that contains multiple series.

There are two types of Mekko charts:

  1. Marimekko chart: A chart with columns that are all 100% height but have variable widths.
  2. Bar Mekko chart: A chart with columns that have variable heights and variable widths.
Free Download: Consulting Presentations

Download 120+ strategy consulting presentations for free

Looking for slide inspiration? Download 120+ consulting slide decks from top strategy consulting firms!

    When should you use them?

    Mekko charts are commonly used in strategy consulting presentations because they are a quick way to show multiple insights in a single visualization.

    Marimekko charts are most commonly used when you have two categorical variables (e.g. industry and company), one quantitative variable (e.g. market capitalization), and want to compare each category as a percentage.

    Marimekko chart example
    An example of a bar Marimekko chart. Source: Mekko Graphics

    Bar Mekko charts are most commonly used when you have one categorical variable (e.g. country), and two quantitative variables (e.g. annual revenue growth and revenue).

    Bar Mekko chart example
    An example of a bar Mekko chart. Source: Mekko Graphics

    Criticisms of Mekko charts

    Although Mekko charts are quite common in consulting presentations, they have a number of criticisms:

    1. They are difficult to interpret. People are good comparing distances (e.g. in a bar or column chart) but not very good at comparing areas (e.g. in a Mekko chart). Because of this, it takes longer for people to interpret Mekko charts.
    2. You can’t include many categories or groups. Mekko charts get extremely cluttered when there are two many categories and/or groups. In particular, it becomes difficult to include readable labels.
    3. There is almost always a simpler alternative. No matter what you’re trying to communicate with your Mekko chart, there’s generally a simpler way to show that same insight. Sometimes it might take two separate charts; but even that can be easier to understand than a Mekko chart.

    How to create a Mekko chart in PowerPoint

    Excel and PowerPoint do not support Mekko charts natively. There are ways to create a Mekko chart in Excel and PowerPoint but they require you to create a stacked areas chart and apply some hacks to make it look like a Mekko chart.

    The better way is to use a PowerPoint charting add-in to create a Mekko chart.

    There are a few add-ins that support Mekko charts, including Think-Cell, Empower Suite, Grunt Pro and Mekko Graphics. But in my experience, the most powerful PowerPoint charting add-on is Think-Cell.

    In the image below, you can see an example of me adding a Mekko chart to the Market & Competitor Analysis Template Pack.

    Think-Cell Charts List (Mekko Charts)
    You can create Mekko charts in PowerPoint using Think-Cell

    To create a Mekko chart using Think-Cell:

    1. Click on Insert on the PowerPoint ribbon
    2. Click on Elements in the Think-Cell section
    3. Click on either Mekko (% Axis) or Mekko (Unit Axis) and then drop the chart onto your slide canvas
    4. When the data sheet appears, insert the data for your Mekko chart

    If you’d like to learn more about using Mekko chart with Think-Cell, check out my YouTube video: The Ultimate Guide to Mekko Charts in Think Cell

    Downloadable PowerPoint Templates and Toolkits

    Your personal database of slide templates to use in any project

    PowerPoint Elements, Shapes, Graphics & Icons Pack
    Slide Templates

    PowerPoint Elements, Shapes, Graphics & Icons Pack

    Over 500+ slide elements: arrows, cycles, pyramids, flows, categories, timelines, charts, jigsaws, cogs and wheels, maps, icons and more!
    View Shapes Pack →
    Corporate & Business Strategy Consulting Toolkit
    Slide Templates

    Market & Competitor Analysis Template Pack

    37 templates for market sizing, segmentation, forecasts, trends, competitor analysis, product comparisons, and more!
    View Analysis Templates →
    Organizational Design and Operating Model Toolkit
    Slide Templates

    Value Proposition & Go-To-Market Template Pack

    Templates for product development, product positioning, roadmaps, pricing strategy, distribution models, and more!
    Coming Soon