Marimekko Charts in Excel: How to Create Market Share Visualizations

Excel does not have a native Marimekko chart type. Every tutorial you find online uses a stacked area chart workaround with helper columns that takes 45-90 minutes to build and breaks the moment someone adds a market segment. This guide covers what Marimekko charts are, walks through the Excel workaround so you understand the trade-offs, and compares it against add-in alternatives. For a broader overview of consulting chart types, see our PowerPoint Charts Guide.

What Is a Marimekko Chart?#

A Marimekko chart (also called a Mekko chart) is a two-dimensional stacked chart where both the width and height of columns represent data values. Unlike a standard stacked bar chart where all columns have equal width, a Marimekko chart uses variable-width columns to encode an additional dimension.

The dual-encoding is what makes these charts powerful for consulting:

• Column width = Market size, revenue, or segment importance
• Column height segments = Market share, composition, or breakdown

Strategy consultants at McKinsey, BCG, and Bain popularized Marimekko charts because they answer multiple questions simultaneously: How large is each segment? Who are the key players? Where are the opportunities?

When to Use Marimekko Charts#

Marimekko charts work best when you need to show two dimensions of proportional data. The most common use cases are market share analysis (width = market size, height = competitor share), share of wallet analysis, portfolio analysis, and competitive landscape mapping.

The key test: does the variable width add meaningful insight? If you only care about one dimension, a standard stacked bar chart is simpler and faster to interpret.

How to Create a Marimekko Chart in Excel (Stacked Area Workaround)#

The most common technique converts your data into cumulative X-coordinates, then uses a stacked area chart to simulate variable-width columns. Here is the process.

Step 1: Prepare your source data as a standard table:

Step 2: Calculate cumulative X-coordinates. Convert market sizes into cumulative percentages using =SUM(B2:B6) for the total, then =B2/$B$7 for each country's proportional width.

Step 3: Create the area chart data structure. For each competitor, build a data series where X values are cumulative boundary positions and Y values are that competitor's share. You need two X-coordinates per column (start and end).

Step 4: Add invisible spacer series set to 0% between each column to create visual separation.

Step 5: Insert a stacked area chart (Insert > Charts > Area > Stacked Area), then format both axes. Set the horizontal axis to "Date Axis" for even spacing, and set the vertical axis maximum to 100%.

Step 6: Add data labels and formatting. Apply colors to each series, position labels, and remove gridlines.

Why This Method Is Problematic#

The formulas for X-coordinates are interconnected. Change one value and you may need to recalculate everything downstream. For any chart that will go through revisions, this approach is not sustainable.

An alternative conditional formatting approach (using a grid of cells with color rules) exists but produces low-resolution output that cannot export cleanly to PowerPoint. It is not suitable for client presentations.

Add-In Alternatives for Marimekko Charts#

Third-party add-ins provide native Marimekko chart support without the workaround complexity.

Mekko Graphics (mekkographics.com) is the original specialist tool, purpose-built for Mekko charts with extensive formatting options.

Deckary provides Mekko charts alongside waterfall charts, Gantt charts, and productivity tools at a fraction of competitor pricing.

Deckary's Mekko chart capabilities include 100% stacked and absolute Mekko charts, automatic width calculation from data, Excel data linking with live updates, and cross-platform support (Windows and Mac). Pricing starts at $49/year (Starter) with a $199 lifetime option.

Excel to PowerPoint: The Linking Challenge#

When you paste an Excel Marimekko workaround into PowerPoint, you face three bad options: paste as a static image (no updates), paste as a linked chart (area chart formatting looks wrong), or paste as an embedded chart (requires editing in Excel). The stacked area workaround produces a chart type that PowerPoint handles poorly.

Add-ins like Deckary solve this by creating the chart natively in PowerPoint while maintaining a link to your Excel data source. Select your data in Excel, click the Mekko button, and the chart appears in PowerPoint with a live link. When data changes, click refresh and all linked charts update automatically.

Best Practices for Marimekko Charts#

Color and Labeling#

Label column widths with both the segment name and absolute value (e.g., "Germany / $15.2B"). For segment labels inside bars, show percentage or absolute value but not both, and remove labels from segments smaller than 5%.

Data Ordering and Category Limits#

Order columns largest to smallest by default. More importantly, keep segment order consistent across all columns. If AWS is on top in the UK column, AWS should be on top in Germany. Inconsistent ordering forces readers to hunt for comparisons.

Common Mistakes to Avoid#

1. Inconsistent segment order across columns makes cross-segment comparison impossible
2. Missing width labels leave readers guessing about actual values behind relative widths
3. Too many segments per column creates visual noise -- group minor players into "Other"
4. Unclear dimension definitions confuse audiences -- always state what width and height represent in the chart title
5. Using Mekko when simpler charts work adds complexity without added insight

Summary#

Marimekko charts are among the most powerful visualizations for market analysis, showing both size and composition in a single view. The challenge is that Excel cannot create them natively. The stacked area workaround takes 45-90 minutes, breaks when data changes, and links poorly to PowerPoint.

Key takeaways:

1. Mekko charts show two dimensions -- width and height both encode data
2. Excel has no native Marimekko chart -- only complex workarounds exist
3. The stacked area method takes 45-90 minutes -- and breaks when data changes
4. Add-ins create Mekko charts in under 60 seconds -- with Excel linking that actually works
5. Limit to 6-8 columns and 4-6 segments -- more creates visual noise
6. Always label widths with absolute values -- relative width alone is meaningless
7. Keep segment order consistent -- same competitor position in every column

For consultants and analysts building Mekko charts regularly, Deckary offers Mekko charts at $49-119/year with a 14-day free trial -- no credit card required.