Charts > Marimekko

How to Build Marimekko Chart Market Share

Debra Dalgleish - Contextures

How to create a Marimekko chart to show colour blocks with market share. Also known as a Mekko graph, these are variable width 100% stacked bar charts. They can show the size of different segments in a market, like the percentage per company and product type example shown below.

marimekko chart 17

Introduction

With a Marimekko chart, the column widths show one set of percentages, and the column stacks show another set of percentages. In the example shown below:

  • market segments (phone, laptop, desktop and tablet), are represented by the width of the columns.
  • each column shows the company percentages for that segment (Acer, Dell, HP, Lenovo)

NOTE: This is fake data, with no relation to real sales figures.

marimekko chart 01

Read a Marimekko Chart

With a quick glance at the Marimekko graph, shown above, you can see that:

  • phone sales are the largest product type - widest column
  • Acer has the largest share of the phone market - tallest segment in the Phone column

You can also see that:

  1. Lenovo's best sales percentage is in the Tablet market
  2. Tablet sales are in the narrowest column - smallest sales of the four product types

Background Notes on Marimekko Charts

These colourful charts got their name from a Finnish design company, Marimekko, which is famous for creating fabric in bold, colourful prints. According to Wikipedia, that company name is a combination of:

  • "Mari" - a shortened version of Maria - a co-founder's middle name
  • Mekko - Finnish word for "dresses"

Here are a few of the other names used for this style of chart, or similar chart type:

  • Mosaic chart, mosaic plot, mekko chart, mekko graph, matrix chart

No Built-In Marimekko Chart

Maybe there will be a built-in Marimekko chart type for Excel one day. For now, however, that chart type is not available in Excel.

The closest you can come, using Excel's built-in chart types, is to create a 100% stacked column chart.

That chart type show column segments with different sizes, but all the columns are the same width.

marimekko chart 01

Another option is to create a 100% stacked area chart, but it doesn't show the segment percentages, just the company percentages. Also, the areas are all in one, with no vertical dividers for the segments

marimekko chart 01

Latest Excel Chart Types

Excel has added a few new chart types recently, but it still doesn't have a Marimekko chart type.

However, you can create your own version, by doing the following (there are detailed steps in the next section):

  1. Carefully rearrange your data
  2. Add a list of percentages for the axis
  3. Build a Stacked Area chart

This pricess will take some you some time, and a bit of patience, but if you're willing to try this chart building workaround, you can find the Marimekko chart instructions below.

The steps below show how to build the basic chart, and you can add formatting and labels later, to enhance the chart.

How to Make a Marimekko Chart

First, to build a Marimekko chart, the original data has to be rearranged.

In this example, the original data was summarized in the table shown in the screenshot below:

  • Segment names are in column A
  • Segment percentages are in column B
  • Company percentages per segment are in columns C, D, E and F

marimekko chart 01

Change Data to Whole Numbers

For this Marimekko technique, the data must be in whole numbers, instead of percentages.

To convert the numbers, follow these steps:

  • First, create another table, below the original table.
  • In the new table, create formulas that link to the percentages, and multiply each value by 100.
    • For example, in cell C12, the formula is: C6 * 100
  • That changes the original value of 25% into the whole number, 25

The values in the new table will be used to build the chart data.

marimekko chart 01

Chart Data Overview

Next, a chart data table will be created. In the chart data table:

  • The data for each segment will be repeated three times.
  • This will create a "steps" effect in the chart, with left, centre, and right points.
  • Between the segment data, rows with zero values will be added.
    • This will create lines down to the 0 point, to visually separate the "steps".
  • A list of cumulative percentages for the segments is created at the left of the data.
    • These values will be used for the X axis, across the bottom the chart.

Start the Chart Data Table

To create headings for the chart data, copy the company names into cells I1:L1

In the next row, type a zero in each column -- that is the point where each column should start.

marimekko chart 17

Add the Segment Data

To create the segment blocks, the data for each segment is added to the chart data table 3 times. (NOTE: The centre points are not used in this example, but can be used to add segment labels later.)

  • Copy the Phone data from cells C9:F9
  • Paste as values in cells I3:L5.
  • Leave a blank row, then repeat those steps for Laptop, Desktop and Tablet.

The completed result is shown below, with colour coding to show the data for each segment.

marimekko chart 17

Add Zero Rows

To complete the main section of chart data, you'll add zeros. These create lines that visually divide the segments.

  • Put zeros in all the blank rows
  • Add anther row of zeros at the end.

marimekko chart 17

Add X Axis Percentages

Next, a column of numbers is added, to the left of the chart data, to show where each segment should begin and end.

These numbers are based on the percentage for each segment. You'll have to do some easy arithmetic while you enter these values -- each percentage is added to the previous total percentage.

  1. The Phone segment is 40%, so it should start at 0%, and end at 40%. Type 0 in H3 and type 40 in H5.
  2. marimekko chart 17

  3. The Laptop segment is 30%. It will start at 40%, where Phone ended. To get the ending point, add 30, so Laptop will end at 70%. Type 40 in H3 and type 70 in H5.
  4. Then, add the start and end numbers for Desktop (70 and 90)
  5. Finally, add the numbers for Tablet (90 and 100)

marimekko chart 17

Add Percentages For Zero Rows

The zero rows are in the data to create lines at the end of each segment. These rows should be at the same percentage marker as the rows before and after them.

So, to fill in the percentages for the zero rows, type in the same value that in the segment row above and/or below.

Here is the chart data with the zero rows filled in.

marimekko chart 17

Add Percentages For Segment Centre

The last thing to do is calculate the midpoint for each set of segment data. For example, the Phone segment goes from 0 to 40, so 20 would be at the centre of that data block.

These values can be used later, to add segment headings to the chart.

To calculate the midpoint for Phone:

  • In cell H4, type the formula: =AVERAGE(H3,H5)
  • Then, copy cell H4, and paste into H8, H12, and H16

Here is the chart data with the segment midpoint rows filled in.

marimekko chart 17

Create a Stacked Area Chart

Now that the data has been set up for the Marimekko chart, it's time to build it.

  • Select the chart data and headings -- cells H1:L18
  • On the Excel Ribbon, click the Insert tab, then click the button for Line Charts
  • In the drop down list, go to the 2-D Area section, and click on Stacked Area

marimekko chart 17

A Stacked Area chart is added to the middle of the worksheet. It doesn't look quite right, but you'll fix that in the next section.

Move and resize the chart, if necessary, so it doesn't cover your data.

marimekko chart 17

Fix the Chart

The chart currently shows flat-topped triangles, instead of the "steps" that we want for the Marimekko chart. The repeated percentages are showing on the X Axis, because those numbers are being treated as text.

To fix the chart:

  • Right-click the X Axis, and click Format Axis
  • Under Axis Option, select Date Axis as the Axis Type
  • For the Major and Minor Units, type 20, and select Days
  • Leave the Format Axis pane open for the next step

marimekko chart 17

  • With the Format Axis pane still open, click on the Y Axis.
  • In the Bounds section, set the Maximum to 100
  • Close the Format Axis pane

marimekko chart 17

The chart changes, to show the Marimekko "steps".

marimekko chart 17

Complete the Marimekko Chart

To complete the chart, follow these steps:

  • Remove the default Chart Title, or change its text.
  • To add a visible outline for the Acer blocks:
    • Click on the Acer series, to select it
    • On the Excel Ribbon, click the Format tab
    • Click Shape Outline, and click a light colour to use for the lines
    • Click the Dell series, then press the F4 key on your keyboard, to repeat the formatting
    • Repeat for the HP and Lenovo series
  • Add text boxes with the Segment Names

Here is a screen shot of the completed chart. With a dark grey border added to the chart shape.

marimekko chart 17

Note: Instead of text boxes, you can add a list of label points and label text, at the right side of the table. Then, add that series as a line chart, and use Rob Bovey's free Chart Labeler add-in to label the points. See the example in the sample workbook, that you can download below.

Marimekko Chart Tool

The simplified Marimekko graph example on this page is based on a complex tutorial on the Peltier Tech website.

In this video, I show the steps for using Jon's Excel Chart utility, so you can see how it works.

Get the Excel Files ✅

To see how the Marimekko chart is created, get the sample workbook. The zipped file is in xlsx format, and does not contain macros.

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

 

Last updated: June 20, 2025 7:27 PM