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.
Cerca de 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.
O caminho exato no PlotSet, de um modelo em branco até o gráfico finalizado.
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.
Comece pelo modelo de Marimekko Chart com dados de exemplo já carregados, depois substitua-os pelos seus.
Abrir o modeloA reta final é igual para todo tipo de gráfico: o Share transforma o gráfico em um link público interativo e em um código de incorporação; o Export gera um arquivo estático.
Ativar o código de incorporação e o link público é o que publica o gráfico. O link pode ser enviado com segurança para qualquer pessoa, e o código de incorporação entra em qualquer página como um iframe que mantém a interatividade e os tooltips ao passar o mouse. Edite o gráfico depois e clique em Recreate para levar essas mudanças aos dois.
O Export grava uma cópia estática no tamanho que você precisar. O SVG continua nítido em qualquer escala e ainda pode ser editado em uma ferramenta de design; PNG e JPG são as escolhas seguras para slides e documentos. É o multiplicador de escala que garante uma imagem nítida em uma tela 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.
Não tem certeza se o Marimekko Chart é a escolha certa? Veja o que é, quando usar e quando evitar.
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.
Grátis para começar com mais de 300 modelos. Sem cartão de crédito.
