mekko chart powerpoint

What is a Mekko chart in PowerPoint?

A Mekko chart in PowerPoint, also called a Marimekko chart, is a variable-width stacked column chart. Column width shows the size of each category, segment height shows the mix inside each category, and segment area shows the category’s contribution to the whole.

The core math is simple enough to audit before you open PowerPoint. If China has more than 13 million electric car sales, Europe has 4.2 million, and the United States has around 1.5 million, the width of each column should be based on those totals, not on equal column spacing. Those figures come from the IEA Global EV Outlook 2026.

Does PowerPoint have a native Mekko chart?

No. Microsoft’s Office chart type list includes column, line, pie, bar, area, scatter, bubble, stock, surface, radar, treemap, sunburst, histogram, box and whisker, waterfall, funnel, combo, and map charts, but it does not list Mekko or Marimekko.

That matters because a Mekko chart is not just a 100% stacked column chart. In a normal PowerPoint stacked column chart, every column has the same width. In a Mekko chart, widths change, so a 13 million unit market is visibly wider than a 1.5 million unit market.

• Native PowerPoint charts can show mix with 100% stacked columns, but they cannot make columns wider or narrower by category total.
• PowerPoint shapes can imitate a Mekko, but manual rectangles are slow to update and easy to mis-size.
• Excel workarounds can create a Mekko-like stacked area chart, then you can paste or link it into PowerPoint.
• PowerPoint add-ins such as think-cell, Mekko Graphics, Ampler, and empower add dedicated Mekko or Marimekko chart tools.

How do I build a Mekko chart for PowerPoint manually?

The manual method is an Excel workaround: calculate cumulative x positions, turn the data into repeated x and y coordinates, insert a stacked area chart, format the horizontal axis as a date or value-like scale, then paste the finished visual into PowerPoint.

Peltier Tech’s Marimekko tutorial describes the key trick: use whole-number cumulative x values such as 0, 40, 70, 90, and 100 instead of raw percentages, repeat each x value three times, and use helper rows for labels. The approach works because the stacked area chart fills variable-width spaces.

Manual Excel-to-PowerPoint steps

• Step 1: Put your category totals in columns and calculate the grand total.
• Step 2: Calculate each column width with Column total ÷ grand total × 100.
• Step 3: Build cumulative x positions, starting at 0 and ending at 100.
• Step 4: Repeat each x boundary so the stacked area chart draws vertical edges instead of diagonal slopes.
• Step 5: Calculate each segment height as Cell value ÷ column total × 100.
• Step 6: Insert a stacked area chart in Excel and force the x-axis to run from 0 to 100.
• Step 7: Add labels for column totals, segment shares, and source notes.
• Step 8: Copy the chart into PowerPoint as an editable chart if you need future updates, or as a picture if the slide is final.

What data do I need for a PowerPoint Mekko chart?

A real PowerPoint Mekko chart needs one complete rectangular table: categories across columns, segments down rows, and every cell filled with the same unit. Totals determine widths; row values inside each column determine stacked heights.

Do not mix units. Revenue in millions, units sold, market size, and percentage share cannot sit in the same source table unless you convert them first. If your source gives only totals, use a bar chart; if it gives totals plus a complete breakdown, use a Mekko chart.

The table above is useful for a PowerPoint width example, but it is not enough for a full two-variable Mekko because China and United States BEV/PHEV splits are not stated in the same extracted IEA text. A clean Mekko would require the missing regional splits from the IEA data product or another audited data table.

When should I use a Mekko chart on a slide?

Use a Mekko chart when the slide has one message about size and mix at the same time: for example, market size by region and product mix inside each region, or revenue by customer segment and margin tier inside each segment.

• Use 3 to 7 columns when the slide must be read in a meeting.
• Use 2 to 5 stacked segments when labels need to fit inside blocks.
• Group tiny segments into Other when several blocks fall below label size.
• Avoid Mekkos for negative values, time series, or datasets with missing cells.

Which PowerPoint add-ins create Mekko charts?

Several PowerPoint add-ins create Mekko charts directly. The best-known options in 2026 are think-cell, Mekko Graphics, Ampler, and empower. They differ in chart library size, workflow, and whether the source data lives in a linked datasheet.

think-cell’s Mekko manual is especially specific about chart geometry: a Mekko is a two-dimensional stacked column chart with varying segment heights and varying column widths, no gaps between columns, and an optional X extent row for unit-based Mekko charts.

How can AnyGen create a Mekko chart PowerPoint?

AnyGen helps when you need the PowerPoint-ready material, not just the definition. Give it the source table, the chart message, and the slide audience; it can generate an editable slide outline, chart instructions, labels, and speaker-ready takeaways.

For a Mekko chart PowerPoint request, the useful input is not a paragraph. It is a structured table with columns, segments, units, source date, and the one-sentence takeaway. AnyGen can also flag when the dataset is incomplete, such as having regional totals without the segment split needed for a true Marimekko.

Copy-and-use AnyGen prompt

Create a 16:9 PowerPoint slide with an editable Mekko chart. Use column width for total market size and stacked height for segment share. Include the formulas Column width = column total ÷ grand total × 100 and Segment height = cell value ÷ column total × 100. Add a short title, source note, and one takeaway. If the dataset is incomplete, tell me what is missing instead of inventing values.

• Best input: a complete cross-tab table with 3 to 7 columns and 2 to 5 stacked segments.
• Best output: one title slide, one Mekko chart slide, one data-source slide, and one takeaway slide.
• Best safety check: require AnyGen to keep the body table and deck_source data identical.

How do I format a Mekko chart so it works in PowerPoint?

A Mekko chart works on a PowerPoint slide only if the reader can decode width, height, and area in under 10 seconds. The formatting job is to reduce visual noise, label the largest blocks, and make the source table auditable.

• Put the conclusion in the title, not in a legend. Example: China is the widest EV market column in 2025.
• Show column totals above or below each column so width has a number attached.
• Use direct labels for large segments and a compact legend only for small recurring segments.
• Limit colors to one palette where the same segment has the same color in every column.
• Add a source note with publisher, report, year, and extraction date.
• Avoid 3D effects, shadows, and decorative gradients because area judgment is already difficult.
• Keep the chart in a large slide area; a Mekko is usually too dense for a small dashboard tile.

Frequently asked questions