A step by step walkthrough for turning a segment, subdivision and value spreadsheet into a published Marimekko chart in PlotSet, from shaping the sheet to locking the stack order and exporting.
Etwa 8 MinutenTake a spreadsheet shaped as segment, subdivision and value, something like revenue by region and sales channel, and this guide shows how to create a Marimekko chart in PlotSet where the column widths carry as much information as the stacks inside them. You will shape the sheet, upload it, lock the column order and the stacking order, then publish, embed or export the finished chart.
If your data is already three columns, one row per block, this takes about eight minutes, and most of that goes into locking the stacking order so it reads the same in every column rather than fighting the upload. Add another five if you are unpivoting a wide report, one column per channel, into the long format PlotSet expects.
Three columns, one row per block: the segment name, the subdivision name, then the number. No totals row, no wide pivot table, one header row.
| Region | Channel | Revenue |
|---|---|---|
| North America | Direct | 420000 |
| North America | Reseller | 180000 |
| North America | Online | 90000 |
| Europe | Direct | 260000 |
| Europe | Reseller | 140000 |
| Europe | Online | 70000 |
| Asia Pacific | Direct | 150000 |
| Asia Pacific | Reseller | 110000 |
| Asia Pacific | Online | 95000 |
This is long format: one row per segment-subdivision pair, not one column per subdivision. If your report has a Direct column, a Reseller column and an Online column side by side, restack those into rows before uploading.
Spell each segment name identically on every row. "APAC" on one row and "Asia Pacific" on another reads as two separate segments and splits a total that should be one column.
Delete any totals or subtotals row before uploading. A grand total uploaded as a row becomes a segment of its own and throws off every width.
Keep the value column numeric. A revenue figure stored as text (a stray currency symbol or thousands separator that survived an export) will not sum into the segment total PlotSet uses to calculate column width.
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
From the PlotSet dashboard, start a new project and choose the Marimekko Chart template. It loads with sample data already bound to segment, subdivision and value, so you can see the exact column layout before touching your own file.
List one row per block: the segment name first (region), the subdivision name second (channel), and the number third (revenue). This is long format, not the wide pivot table most reporting tools export by default, where each channel gets its own column.
If your source is a table with one column per subdivision, say a region row with a Direct, Reseller and Online column each, stack those columns into rows instead: one row per region-channel pair, three columns total. A quick copy-paste rebuild handles this faster than it sounds.
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet so the chart can pick up later edits without a re-upload. PlotSet reads the first row as headers automatically.
Confirm which column feeds the column width (segment), which feeds the stack (subdivision), and which feeds the block size (value). Column widths are calculated for you from the segment totals: you never enter a width directly.
Sort columns widest to narrowest so the biggest segment reads first, left to right. Then set the subdivision order once and keep it identical in every column: if Direct sits at the bottom in North America, it needs to sit at the bottom in Europe and Asia Pacific too, or the chart stops being comparable across columns.
Switch on the cumulative top axis so the segment widths are readable instead of just implied by eye. Add value or percentage labels to each block; without them a reader has to estimate two dimensions at once, which is the main thing that makes a Marimekko hard to read.
Assign one color per subdivision and keep that mapping constant across every column, the same way you kept the stacking order constant. Then publish for a live interactive chart with hover tooltips, grab the embed code for a page, or export a PNG, SVG or PDF for a deck.
Starten Sie mit der Marimekko Chart-Vorlage samt bereits geladenen Beispieldaten und ersetzen Sie diese durch Ihre eigenen.
Vorlage öffnenDer letzte Abschnitt ist bei jedem Diagrammtyp gleich: "Share" macht aus dem Diagramm einen öffentlichen Live-Link und einen Einbettungscode, "Export" schreibt es als statische Datei heraus.
Aktivieren Sie den Einbettungscode und den öffentlichen Link, um das Diagramm zu veröffentlichen. Den Link können Sie bedenkenlos an alle weitergeben, und der Einbettungscode fügt sich als iframe in jede Seite ein. Die Tooltips beim Überfahren mit der Maus und die volle Interaktivität bleiben erhalten. Wenn Sie das Diagramm später bearbeiten, überträgt "Recreate" die Änderungen auf Link und Einbettung.
"Export" schreibt eine statische Kopie in der Größe heraus, die Sie brauchen. SVG bleibt in jeder Skalierung scharf und lässt sich weiterhin in einem Design-Tool bearbeiten; PNG und JPG sind die sichere Wahl für Folien und Dokumente. Der Skalierungsfaktor sorgt dafür, dass das Bild auf einem Retina-Display gestochen scharf wirkt.
The width of each column is half of what a Marimekko encodes, and it is the half readers miss most often. A cumulative scale along the top turns an implied comparison into one they can actually read.
Set the stacking order once, confirm it holds across every column, and only then start assigning colors. Reordering after coloring means redoing the color mapping too.
A subdivision too small to get its own labeled sliver just clutters the chart. Fold it into a named Other block per column rather than leaving a row of unreadable slivers.
Six columns and five stacks is already a lot to compare by area. Past that, filter to the segments that matter (top regions, top categories) and say so in the title or a caption.
This usually means the value column uploaded as text rather than a number, or two rows spelled the segment name differently ("APAC" versus "Asia Pacific") so PlotSet cannot sum them into one segment total. Fix the spelling or the number format in the source sheet and re-upload.
Each column is sorting its subdivisions independently, usually by value, instead of using one fixed order. Set the subdivision order explicitly in the chart settings rather than leaving it on automatic, and it will hold across every column.
Too many segments, too many subdivisions, or both. Filter the segments to the ones carrying the story and fold small subdivisions into an Other block before uploading again.
Nicht sicher, ob Marimekko Chart die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Three: a segment (the column), a subdivision (the stack inside it), and a value. One row per segment-subdivision pair, in long format. PlotSet calculates each column's width from the segment totals, so you never enter a width directly.
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.
