A step by step walkthrough for turning a spreadsheet into a published treemap in PlotSet, from shaping the category and parent columns to exporting or embedding the finished tiles.
Etwa 8 MinutenThis is how to create a treemap in PlotSet from your own spreadsheet: tiles sized by value, grouped by hierarchy, coloured on purpose, then published as a live embed or exported as an image. Your own rows go through the same upload-to-publish path a real PlotSet treemap takes, including the one column that trips people up: the parent.
If your spreadsheet already has a category, a parent and a value in three columns, eight minutes gets the whole thing done. Pulling the data out of a pivot table first adds another five, since pivot exports usually carry subtotal rows that need to come out before the tiles will size correctly.
Three columns, one row per tile: the category name, its parent group (blank for a top-level tile), and a positive number. One header row, no subtotal rows.
| Category | Parent | Revenue |
|---|---|---|
| North America | 4200000 | |
| Europe | 3100000 | |
| Asia Pacific | 1800000 | |
| United States | North America | 3300000 |
| Canada | North America | 900000 |
| Germany | Europe | 1400000 |
| France | Europe | 900000 |
| United Kingdom | Europe | 800000 |
| Japan | Asia Pacific | 1100000 |
| Australia | Asia Pacific | 700000 |
Leave the parent column blank for a top-level row, not filled with a placeholder like "None" or "Top". A blank cell is how PlotSet knows a tile has no ancestor; a text placeholder gets read as an actual parent name and adds a stray tile.
Every value must be zero or greater. A negative revenue or a loss row will not render as a tile, since a rectangle cannot have negative area, so pull those rows into a separate table before you upload.
If you are working from a pivot table, delete the grand total and subtotal rows first. A "Total" row uploaded alongside real categories becomes a tile of its own, usually the largest one on the page.
A flat treemap with no hierarchy works too: just leave the Parent column out entirely, or leave every cell in it blank, and every row becomes a top-level tile.
Parent names have to match a Category value exactly, including case and spacing. "north america" in the Parent column will not find "North America" in Category, and that child tile gets dropped.
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
From the PlotSet dashboard, start a new project and choose the Treemap template. It loads with sample data already bound, tiled by category, parent and value, so you can see the exact three-column shape before you swap in your own file.
One row per tile: its name, the group it sits inside, and its size. If your source is a pivot table or a finance report, pull those three fields out into a plain flat sheet first. No merged cells, no subtotal rows.
Use the data panel to import a CSV or .xlsx file, paste rows straight from a spreadsheet, or connect a Google Sheet so the treemap can be refreshed later without a re-upload. PlotSet reads the first row as headers.
Confirm which column feeds the tile name, which one feeds the parent group, and which one sizes the tile. PlotSet usually guesses right when your headers are clear, but check it manually if your sheet has extra columns sitting between them.
Look for a top-level tile that is really a stray parent name, or a child tile that vanished because its parent value did not match exactly. Fix mismatches in the source sheet and re-upload rather than patching the chart by hand.
Size is already spoken for by the tile's area. Set the colour scale to the parent group so the hierarchy reads at a glance, or switch it to a second numeric column, growth rate or margin, if you want colour to carry a different story than area does.
PlotSet hides labels automatically once a tile gets too small to fit text without overlapping its neighbours. Leave that behaviour on rather than forcing every tile to label, and rely on the hover tooltip to surface the exact value for the small ones.
Publish for a live interactive treemap with hover tooltips and a shareable link, grab the embed code to drop it into a page, or export a PNG, SVG or PDF if you need a static image for a deck or a report.
Starten Sie mit der Treemap-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.
If your data has three big categories and forty tiny ones, the tiny ones will shrink into unreadable slivers regardless of how you colour them. Sum the small rows into a single "Other" row before upload, and mention in a caption what it covers.
A treemap gives you two channels to work with: area for value, colour for anything else. Wasting colour on the same value the area already shows (a common default) throws away half the chart's power. Try colouring by year-over-year change instead.
PlotSet will nest a third level, but by the time tiles are three groups deep, individual rectangles are too small to compare or even see. If your data goes deeper, pick the two levels that matter most to the reader and flatten the rest.
"Other" on its own reads as a shrug. "Other: 14 regions under $50k" tells the reader exactly what got folded in and why it is not broken out, without them needing to ask.
The parent name in that row almost certainly does not match a category value exactly, often a trailing space or a different capitalisation. Compare the two columns directly in the spreadsheet, fix the mismatch, and re-upload rather than editing inside PlotSet.
This is usually a subtotal or grand total row from a pivot export that got uploaded as if it were a real category. Scroll to the bottom of the source sheet, delete the totals row, and re-upload.
It is not broken: PlotSet is hiding labels that would overlap or overflow a small tile. Check the hover tooltip to confirm the value is still there, and if you need more tiles labelled, group the smallest ones into an "Other" tile so the remaining ones have more room.
Nicht sicher, ob Treemap die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Three columns: category, parent, and value, with one row per tile. Leave the parent blank for top-level tiles, or drop the column entirely for a flat treemap with no hierarchy. CSV and .xlsx both work.
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.
