Charts > Marimekko

# How to Build Marimekko Chart Market Share

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.

## 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.

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.

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

### 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):

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

### 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.

### 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.

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.

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.

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. 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.
3. Then, add the start and end numbers for Desktop (70 and 90)
4. Finally, add the numbers for Tablet (90 and 100)

### 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.

### 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.

### 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

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.

### 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

• 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

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

### 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.

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. For detailed instructions, go the Peltier Tech website, and search for the Marimekko instructions.

## Quick and Painless Marimekko Chart

Note: These are affiliate links, and I'll earn a small commission if you purchase the chart utility through these links.

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

If you don't have the time or patience to arrange your data and create your own Excel Marimekko chart, Excel charting expert, Jon Peltier, offers a time-saving Excel Chart Utility.

Reasonably priced, the Peltier Tech chart add-in will quickly pay for itself, because you won't waste your time fiddling with data arrangements and chart settings.

This video shows the steps for using the Excel Chart utility, and the written instructions are below the video.

For this demo chart, I created a pivot table from the sales data, and sorted the segments by Grand Total.

Then I selected the headings and data (F5:J9), and clicked the Marimekko button on the Ribbon.

In the dialog box, I choose the Series in Columns Orientation, and clicked OK, as shown below.

Instead of a long, painful process, the Marimekko chart is created in a few seconds. A new sheet is inserted in your workbook, with data linked to your original data, and completed Excel Marimekko Chart.

You can adjust the label text, and other options, by using the yellow cells and check boxes on the worksheet. Then, move the chart to a different sheet, for your final report.

Here's the completed Excel Marimekko chart, showing the segment percentages across the X axis, and company percentages within each segment. This one took a couple of seconds to complete -- much faster than building it manually!

#### Get the Peltier Tech Chart Utility

If you need to make a Marimekko chart, or other custom Excel charts, go to the Peltier Tech website, and check out the features in the Peltier Tech Chart Utility.

Instead of copying and pasting data, and fussing with the chart formatting, just click a button to create a complex chart. You'll save time and reduce frustration, and your boss and clients will be impressed by how quickly and easily you can create complex Excel charts.

There are several other custom chart types in this All-in-One Chart Tool, including Waterfall, Stacked Waterfall, Cluster Stack, Histogram, Box Plot, Dot Plot, and Pareto.

The tool also includes a Loess data tool, and several other chart management and formatting tools, like Export Chart, and Label Last Point.

## Get the Workbook

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

Last updated: July 29, 2022 12:41 PM