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.
约 8 分钟Take 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.
PlotSet 中从空白模板到完成图表的具体点击路径。
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.
从已加载示例数据的 Marimekko Chart 模板开始，再替换成你自己的数据。
打开模板最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
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.
不确定 Marimekko Chart 是否是正确选择？查看它是什么、何时使用以及何时不使用。
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.
免费开始，300+ 模板任选。无需信用卡。
