10 steps to create a Marimekko chart in PowerPoint

6 min read
April 21, 2021

A Marimekko chart displays an overall picture with multiple variables at a glance. For example, a Marimekko chart can show a company's sales per product and per region at the same time. We will show you how to present data clearly in a Marimekko chart with examples. You will also learn how to create a Marimekko chart in PowerPoint and how to highlight the key message of your chart.

A Marimekko chart combines data sets and displays them clearly 

create marimekko chart in powerpoint

If you want to show sales per product, per region/area, you can use a Marimekko chart to show each regioneach product, and their respective sales all at once. 

create marimekko chart in powerpoint

You can also mix completely different data, like digital or classic home entertainment usage: your categories could be Digital and Classic in relation to Streaming Subscription or Purchase.  

Are there any differences between Mekko charts, Marimekko charts and the PowerPoint Treemap?  

Before we show you how to create a Mekko chart in PowerPoint, we want to clarify the different terms. Both the Marimekko chart and the PowerPoint Treemap count as Mekko chartsBut there are differences between the two.  

The Marimekko chart consists of bar charts stacked side by side, with each axis representing 100%. Products A, B, and C add up to 100% of sales of all products and Areas A, B, and C constitute 100% of sales of all regions. In this example, you can see that Product A has the most revenue because the bar is the widest.  

create marimekko chart in powerpoint
In 
a Treemap chart, the sheets are not stacked but arranged side by side within a category. With a Treemap, only categories and subcategories are compared with each other. In addition, no values are displayed, which you must insert manually in the settings.  

treemap create marimekko chart in powerpoint

Which type of Mekko chart is most suitable for you is up to you. Both native Treemap charts and Marimekko charts can be created directly in PowerPoint. You can create them and other diagrams without dedicated charting software or save yourself time with the PowerPoint add-in empower®.

Manual method: 10 steps to create a Marimekko Chart 

  1. Convert your data sets into percentages.

    create marimekko chart in powerpoint step 1
  2. Just for this exercise create a table in Excel with 100 rows where product A takes up 60 rows because it has 60% of sales.

    create marimekko chart in powerpoint step 2
  3. Insert as many columns as you need to include your subcategories (Online Sales, Store Sales). Then for Product A enter all the data in percentages and copy them 60 times into the Product A rows. Do this for each category.  

    step 3 create marimekko chart in powerpoint

  4. Select the new table and choose the "Stacked columns" option.

    step 4 create marimekko chart in powerpoint

  5. Copy the chart and paste it into PowerPoint.
  6. Click with the right mouse button on a column and then on Edit data series.  
  7. Enter the number 0 in the "Distance width" area.  
  8. Click on the vertical axis and enter the value 100 in the "Maximum" field.

    step 5 create marimekko chart in powerpoint

  9. Delete all duplicate product names on the X-axis.
  10. To look more like a Marimekko chart, click on the legend and then also "place right". 

Upgrade your presentations. Download free PowerPoint business template now!

 

Streamlined method: Create Marimekko chart with just a few clicks 

The PowerPoint add-in empower® saves you valuable time when creating and formatting a Marimekko chart. In less than a minute you can create the chart with correct formatting directly in PowerPoint. 

Just click on Insert, Chart, and Marimekko in the empower® ribbon: you have created your chart! Above the Marimekko chart, you can link your chart directly to existing Excel data.  

empower create marimekko chart in powerpoint

Highlight your Mekko chart’s message 

Your presentation can benefit from an easy-to-understand but highly meaningful Marimekko chart. In the following section, you will learn about quality-enhancing chart formatting from empower® to highlight the key messages of your data. 

  1. Use arrows to show trends
    Focus visualization of your values’ growth behavior using automatically generated arrows above and beside the Marimekko chart.

    create marimekko chart in powerpoint highlights
    (This formatting is located directly above the chart)

    Just click directly above the chart in the leftmost field and choose under Growth Arrows, CAGR Arrows, or Delta Lines depending on what kind of growth you want to highlight with an arrow. 

  2. Sum label directly above a category

    create marimekko chart in powerpoint highlights
    (Insert totals with a double click on the respective category)

    You can also generate some labels directly above the chart in the second box from the left with a few clicks. 

  3. Make differences in your values more obvious with a column Mekko

    create marimekko chart in powerpoint differences in values

    You can convert the Marimekko chart to a Column Mekko with 4 clicks directly above the chart. 
    First, click on the chart you want to convert. Secondly, click on the third box directly above the chart. Then click on “convert this chart” and at last click on mekko chart and you are good.

Get more special charts like the Marimekko directly in PowerPoint  

We hope this introduction to Marimekko charts will help you. A Marimekko chart is a good choice if you have data sets with multiple variables, like different product performances in multiple countries. Besides the Marimekko chart, empower® includes many other special charts directly in PowerPoint. These include Gantt and  Waterfall charts. Here is a list of the most useful PowerPoint chartsWith empower® you can include all formatting to save time and use features like arrows or totals with just a few clicks. You can find all information about empower® Charts on our website. 

New call-to-action

Subscribe to our newsletter