|
Charts > Marimekko How to Build Marimekko Chart Market Share
|

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:
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:
You can also see that:
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:
Here are a few of the other names used for this style of chart, or similar chart type:
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

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

For this Marimekko technique, the data must be in whole numbers, instead of percentages.
To convert the numbers, follow these steps:
The values in the new table will be used to build the chart data.

Next, a chart data table will be created. In 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.)
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.

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.


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.

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:
Here is the chart data with the segment midpoint rows filled in.

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

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.

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:


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

To complete the chart, follow these steps:
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.
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.
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