Brand Control logo

Make it easy for users to stick to your brand — not to ignore it. 

Content Enablement Logo

Make it easy for users to find the right content instantly.

Content Creation logo

The solution for maximum efficiency in presentation creation.

Document Automation logo

The document editing and assembly process is streamlined.

People

Learn more about our clients and their success stories

Gears

Integrate empower® with your existing applications.

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 

Asset_Library

Everything you need to know about the MS Office world. Clearly summarized.

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. 

Best_Practice_Series

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

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

Security

Your data is private and secure with empower®

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 

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

You May Also Like

These Stories on PowerPoint

Subscribe by Email