Mekko Chart

This step-by-step guide will show you how to create a Mekko chart in all versions of Excel: 2007, 2010, 2013, 2016, 2019, and Excel 365.

Here are the steps to create a Mekko chart:

How to create a Mekko (Marimekko) Chart in Excel?

The bad news is that Excel does not have native mekko chart support. If you want to create a mekko chart in a single click to save your time, use our add-in.

Here is our initial data set. We will analyze four products and four quarters. Here is the market share for each quarter:

mekko chart base data

#1: Set up a helper table and add data

The first step is to create a simple structure (helper table) in range I1:L17. Then, make the same header for quarters and copy the data to the destination cells.

mekko chart helper table

#2: Append the helper table with zeros

Insert “0%” below each group.

append the helper table with zeros

#3: Apply a custom number format

Insert a new row and apply a custom number format.

Select the range, right-click and choose ‘Custom’. Enter: 0″%”, so we’ll get the proper number format.

add custom format

#4: Calculate and add segment values

To calculate the relative market share, apply the following formulas in the new column:

  • =SUM($B$2:$B$2)*100 for H5 and H7
  • =SUM($B$2:$B$3)*100 for H9 and H11
  • =SUM($B$2:$B$4)*100 for H13 and H15

Enter 0% in cell H3 and add 100% to cell H17.

Calculate and add segment values

#5: Set up the horizontal axis values

To separate the columns of the Mekko chart, copy the data using the structure below:

Set up the horizontal axis values

#6: Calculate midpoints

To calculate the midpoints for each group, use the following formula in cell H4:

=(H3+H5)/2

Copy the formula down and fill the empty cells in the selected column using this logic.

Calculate midpoints

#7: Add labels for rows and columns

To create labels for all groups, we need to concatenate two cells.

The formula in cell N4:

=A2&TEXT(B2, ” (#%)”)

Add labels for rows

After that, locate the midpoint rows and copy the market share labels into the range O:R.

Set up the product share labels

#8: Insert a stacked area chart

To insert a chart, select range H1:N18, then go to the Insert Tab on the ribbon.

Insert a stacked area chart from the 2D area group.

insert a stacked area chart to create mekko charts

#9: Change series chart type for segments

Select the Label Marker series, right-click and choose ‘Change Series Chart Type…’

change series chart type

The ‘Change Chart Type’ dialog box will appear. From the series names, select the Label Marker and change the chart type to ‘Line with Markers’.

line with markers

#10: Add and Format labels

First, select the “Label Marker” series. Right-click on the blue marker and select “Add Data Labels”.

add data labels

Now we have the labels. First, select labels, then click “Format Data Labels”.

format data labels

Here are the steps to prepare the labels:

Locate the Label Options tab on the right pane and ensure that the “Value From Cells” box is checked. Next, click on the “Select Range” button; a small window will appear.

select data label range for the mekko chart

Highlight cells that contain labels and click OK. Check the “Label Options Group” and leave the “Value” box empty. Finally, set the “Label Position” to “Above”.

label options

Now we have the arranged labels for each product.

product labels are ready

#11: Hide the line chart

The next important step is to hide the line chart. Please don’t delete it!

Select the line chart and use the “Format Data Series” option. Then, under the “Line” section, select “No line”. Now jump to the Marker group and select “None”.

hide the line chart

#12: Format horizontal and vertical axis

We have just a few minor modifications, and our Mekko chart will be ready. First, modify the horizontal axis!

Select the horizontal labels and look at the right side pane. Under the “Axis Type” group, select the Date axis. Replace the default values for “Units”. In this case, enter 10.

format mekko chart horizontal axis
Let us see the vertical axis. Select the axis, and use custom formatting by setting the maximum bounds to 1.
format mekko chart vertical axis

#13: Insert a label to display market share

To add labels for all segments, repeat the steps in section #10.

Insert a label to display market share

#14: Add borders to separate areas

We’ll split the segments and finalize the mekko chart for better readability.

Select the section that you want to split and right-click on it. A floating window will appear; select the outline color and choose the line width.

Add borders to separate areas

Now, the mekko chart is ready!

Mekko chart Add-in

If you are in a hurry and want to skip the steps above, we recommend using our chart utility.

Here is our Mekko chart example. The procedure can take only 1 second using UDT.

mekko chart single click

Download Excel Mekko Chart template

Market share chart in Excel

Additional resources: