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.
Environ 8 minutesThis 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.
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
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.
Partez du modèle Treemap 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.
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.
Vous n'êtes pas sûr que le Treemap soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
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.
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.
