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.
Unos 8 minutosTake 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.
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
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.
Empieza con la plantilla de Marimekko Chart, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaEl último tramo es igual en todos los tipos de gráfico: Share convierte el gráfico en un enlace público en vivo y un código de incrustación, y Export lo guarda como un archivo estático.
Al activar el código de incrustación y el enlace público, el gráfico queda publicado. El enlace se lo puedes enviar a cualquiera sin problema, y el código de incrustación se coloca en cualquier página como un iframe que conserva los tooltips al pasar el cursor y toda la interactividad. Si editas el gráfico más adelante, haz clic en Recreate para llevar esos cambios a ambos.
Export guarda una copia estática en el tamaño que necesites. El SVG se mantiene nítido a cualquier escala y se puede seguir editando en una herramienta de diseño; PNG y JPG son la opción segura para diapositivas y documentos. El multiplicador de escala es lo que te da una imagen nítida en una pantalla 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.
¿No estás seguro de que el Marimekko Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
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.
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.
