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.
Environ 8 minutesTake 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.
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
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.
Partez du modèle Marimekko Chart avec des données d'exemple déjà chargées, puis remplacez-les par les vôtres.
Ouvrir le modèleLa dernière ligne droite est la même pour tous les types de graphique : 'Share' transforme le graphique en lien public actif et en code d'intégration, 'Export' l'enregistre sous forme de fichier statique.
Activer le code d'intégration et le lien public revient à publier le graphique. Le lien peut être envoyé à qui vous voulez sans risque, et le code d'intégration s'insère dans n'importe quelle page sous la forme d'une iframe qui conserve les infobulles au survol et l'interactivité. Si vous modifiez le graphique par la suite, cliquez sur 'Recreate' pour répercuter ces changements sur le lien comme sur le code.
Le bouton 'Export' génère une copie statique à la taille dont vous avez besoin. Le SVG reste net à toutes les échelles et peut encore être modifié dans un outil de design ; PNG et JPG sont les choix sûrs pour les présentations et les documents. C'est le multiplicateur d'échelle qui vous donne une image nette sur un écran retina.
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.
Vous n'êtes pas sûr que le Marimekko Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
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.
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.
