mio

Our add-in suite will make MS Office easy, efficient and brand compliant.

slides

Our add-in for MS PowerPoint with a slide library, corporate design check and productivity tools

charts

Our add-in for MS PowerPoint to create professional charts like waterfall and gantt charts in no time

docs

Our add-in for MS Word to create consistent documents with all legal information up-to-date

mails

Our add-in for MS Outlook to manage email signatures for enterprises

sheets

Our add-in for MS Excel to create highly professional Excel spreadsheets in no time

Gears

Integrate empower® with your existing applications

People

Learn more about our clients and their success stories

Convert_From_Old_To_New

Your new brand in Microsoft Office with empower® in just a few clicks 

Template_Libraries_With_Slides_Icons_Images

All Office templates & signatures always up-to-date and available for everyone

Design_Check

All Office documents & signatures designed from a single source

Asset_Library

The right content, at the right time, in the right place

Gears

Strengthen efficiency and collaboration in your company

Blog

Get practical office tips, inspirational stories, and exclusive market assessments of the MS Office world

E-Books

Find MS Office related guides, e-books, whitepapers, videos, infografics and more 

Best_Practice_Series

Our empower® Best Practice Series shows empower use cases in short 15min videos

Office_Study

The Ultimate Global Office Suite Study - conducted by Nielsen

Office_Study

The Ultimate Office Suite Study for USA - conducted by Nielsen

Powerpoint_Study

Download our global PowerPoint Study conducted by Nielsen

Support

Our support is always there for you. You can also reach out to our Help Center. 

Company

Learn about our values and why we get out of bed every morning

Microsoft_Partnership

Find out more about our very unique relationship with Microsoft

Press

An overview of the press releases about empower

Contact

Contact us at any time if you have any questions or feedback

Career

Find out now about the most important reasons for a career with us! Apply now!

10 steps to create a Marimekko chart in PowerPoint

Theresa Spiller
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 

Marimekko Chart 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. 

Marimekko Chart example

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 clarify the different terms. Both the Marimekko chart and the PowerPoint Treemap count as a Mekko chart. But 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% sales of all products and Areas A, B, and C constitute 100% sales of all regions. In this example, you can see that Product A has the most revenue because the bar is the widest.  

Marimekko Chart example 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 Mekko Chart 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 either create them the hard way (manually) 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.

    workaround Marimekko Chart  PowerPoint Excel
  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.

    workaround Marimekko Chart  PowerPoint Excel
  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.  

    Mekko Chart

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

    workaround Marimekko Chart  PowerPoint Excel

  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.

    Mekko Chart (3)

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

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 marimekko chart 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.

    marimekko chart with arrows
    (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

    marimekko chart with sums
    (Insert totals with a double click on the respective category)

    You can also generate sum 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

    column mekko chart in powerpoint empower

    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. 

E-book PowerPoint charts

You May Also Like

These Stories on PowerPoint

Subscribe by Email