7-Step Guide to Building a Mekko Chart with Mekko Chart Creator
A Mekko chart (Marimekko) shows categorical widths and stacked values together—great for market share, product mixes, and revenue breakdowns. This 7-step guide walks you through building a clear, effective Mekko chart using Mekko Chart Creator.
Step 1 — Prepare your data
- Columns required: Category (x-axis segments), Subcategory (stack segments), Value (numeric).
- Arrange: Each row = one stacked segment within a category.
- Check totals: Ensure category totals (sum of Value per Category) reflect the relative widths you want.
Step 2 — Choose chart dimensions and scope
- Define x-axis categories (e.g., regions, product lines).
- Decide stacks (e.g., channels, segments) and whether to include percentages, absolute values, or both.
- Set date range if data is time-bound.
Step 3 — Import data into Mekko Chart Creator
- Upload CSV or copy/paste table into the data panel.
- Map fields: Assign Category → X, Subcategory → Stack, Value → Measure.
- Validate: Use the preview to confirm totals and segment counts.
Step 4 — Configure scales and sizing
- Normalize widths: Choose whether widths represent raw totals or normalized percentages.
- Axis settings: Turn on/off axis labels and gridlines per readability.
- Chart aspect ratio: Wider canvases help avoid cramped stacks for many categories.
Step 5 — Style for clarity
- Color palette: Assign distinct, colorblind-friendly colors for stacks; use consistent hues for the same subcategory across categories.
- Labels: Show category totals on the bottom and segment labels inside bars if space allows. Use abbreviations for long labels.
- Legends: Place legend top or right; hide if labels are self-explanatory.
Step 6 — Add annotations and interactions
- Tooltips: Include value, percentage of category, and percentage of total.
- Annotations: Highlight key segments with callouts (e.g., “+12% YoY”).
- Filters & drilldowns: Add interaction to isolate categories or reveal underlying data.
Step 7 — Export and iterate
- Export formats: PNG/SVG for images, PDF for reports, or interactive embed for dashboards.
- Review with stakeholders: Validate that chart answers the intended question (market share, composition, etc.).
- Iterate: Simplify if readers struggle—fewer categories, aggregated minor segments into “Other,” or use supplementary charts.
Quick checklist before publishing
- Data sanity: Totals match source.
- Readable colors & labels.
- Correct mappings: Category, Subcategory, Value.
- Helpful tooltips & legend.
- Appropriate export format.
Use this workflow to produce Mekko charts that accurately communicate relative proportions and compositions.
Leave a Reply