The Power-user Mekko chart is a feature of the Power-user add-in for Excel that creates a Mekko chart (also called Marimekko or market map) in one click from a simple table. A Mekko shows in a single chart the size of each segment and the split of each segment, which makes it a favorite of strategy consultants to analyze a market by customers, players, products or channels.
Legacy feature: this article covers the Mekko chart of the Power-user ribbon in Excel. To add a Mekko chart to a PowerPoint slide, use the Mekko template of the Power-user Library: see Library - Charts.
In short
- Where: Create Mekko chart in the Power-user tab of Excel
- Your data: a table with the segments in rows (for example countries) and the split in columns (for example products)
- Edit: right-click the chart and click Edit Mekko chart to change titles, totals, colors and labels
- In PowerPoint: insert a ready-made Mekko from the Library
In this article
What is a Mekko chart?
A Mekko chart is a stacked chart where the columns have variable widths. Instead of several bar charts, it shows at the same time the weight of each segment (the width of the columns, for example channels or countries) and the split of each segment (the height of the blocks, for example products).

Mekko chart in Excel: market by country and by product
This single chart tells a lot:
- the US is the biggest market (240m, 24% of the total), closely followed by China (237m, 23%);
- product D sells the most (28% of the total), ahead of product A (26%) and product E (23%), while products B and C weigh less (9% and 15%);
- the largest segments are product A in the US (92m) and product D in China;
- product C has a small share of the total market, but it is the best seller in Germany.
The longer you look at a Mekko, the more you learn about market opportunities and dynamics, and about the strategy and positioning of each player.
How to create a Mekko chart in Excel
Organize your data as a simple table. The rows and columns of the table become the rows and columns of the Mekko: with countries in rows and products in columns, you get the chart above.

Data source of a Mekko chart: countries in rows, products in columns
- In Excel, on the Power-user tab, click Create Mekko chart.
- In the dialog box, select your data, including the row and column headers.
- Click OK. The Mekko chart is created automatically.
How to edit a Mekko chart
When you create a Mekko chart, the edit pane opens on the right of the screen. To open it again later, right-click the chart and click Edit Mekko chart.
Chart Options
The edit pane opens on the Chart Options tab, where you can:
- add, remove or edit the chart title;
- change the color of the borders;
- show or hide the totals of the series, categories, labels or of the whole chart, as values, percentages or both;
- set the number of decimals for values and percentages.

Chart Options tab of the Mekko chart edit pane
Series Options
In the Series Options tab, select a series of the chart, then:
- change the fill color of this series only;
- change the color, font size and other settings of its labels.

Series Options tab of the Mekko chart edit pane
Mekko charts in PowerPoint
To add a Mekko chart directly to a slide, insert the ready-made Mekko from the Charts tab of the Power-user Library. See Library - Charts.

Mekko chart in PowerPoint: market share by player and region
Power-user also creates Sankey charts in Excel, another chart that Excel does not offer natively.
Frequently asked questions about Mekko charts
What is a Marimekko chart used for?
A Marimekko or Mekko chart is used to segment a market or a company activity, for example by country and by product, by customer or by channel. The width of each column shows the weight of each segment and the height of each block shows its split.
Can you make a Mekko chart in Excel?
Not natively: Excel has no Mekko chart type. With the Power-user add-in, click Create Mekko chart in the Power-user tab of Excel, select your data and click OK; the Mekko chart is created automatically.
How should I organize my data for a Mekko chart?
For a Power-user Mekko chart, use a simple table: the rows become the segments of the chart (for example countries) and the columns become the split of each segment (for example products). Select it with its row and column headers.
What is the difference between a Mekko and a stacked bar chart?
In a stacked bar chart, all the columns have the same width. In a Mekko chart, the width of each column is proportional to its total, so you see both the size of each segment and its split in a single chart.
How do I make a Mekko chart in PowerPoint?
Insert the ready-made Mekko chart from the Charts tab of the Power-user Library in PowerPoint. The Create Mekko chart button of the Power-user ribbon is only available in Excel.
How do I show percentages on a Mekko chart?
In the Chart Options tab of the Power-user Mekko edit pane, show the totals of the series, categories, labels or whole chart as values, percentages or both, and set the number of decimals.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article