Exemple de CSV
| Node | Parent | Spend |
|---|---|---|
| Marketing | ||
| Paid Search | Marketing | 42000 |
| Paid Social | Marketing | 31000 |
| Organic Content | Marketing | 18000 |
| Google Ads | Paid Search | 27000 |
| Bing Ads | Paid Search | 15000 |
| Instagram Ads | Paid Social | 19000 |
| Facebook Ads | Paid Social | 12000 |
How to Create a Sunburst Chart
A step by step walkthrough for turning a spreadsheet of parent, child and value rows into a published sunburst chart in PlotSet, from shaping the sheet to exporting the finished rings.
Environ 9 minutesRings sized by value and coloured by branch, published as a live embed or exported as a static image: this guide is how to create a sunburst chart in PlotSet from your own spreadsheet. The columns below are the exact node, parent and value columns the PlotSet sunburst template expects, not a simplified stand-in for them.
Nine minutes gets you there when your rows are already three clean columns: node, parent, value. A source report that only lists department totals adds another five, since you'll need to add the missing middle level of the hierarchy yourself before anything renders correctly.
Les données dont vous avez besoin
One row per node, three columns: the node's own name, the name of its parent (blank for the top level), and its value. Every parent name must match another row's node name exactly.
Leave the parent column blank only for the root node or nodes. Every other row needs a parent value that matches another row's node name exactly, including case.
Leave the value blank on any node whose number should be computed from its children. PlotSet sums descendants automatically, and typing your own figure there is how rings end up not matching their children.
Node names must be unique across the whole sheet, not just within one branch. If two branches each have a leaf called "Other," rename them ("Search Other," "Social Other") or PlotSet will merge them into one segment.
Keep the value column numeric with no currency symbols or thousands separators. A stray comma or dollar sign turns the whole column to text and every arc collapses to zero.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 01
Open the Sunburst Chart template
From the PlotSet dashboard, start a new project and choose the Sunburst Chart template. It loads with a small sample hierarchy already bound, so you can see exactly how a node, parent and value row turns into a ring before you touch your own file.
Chaque guide commence ici. Choisissez la catégorie, puis le modèle : c'est la même grille quel que soit le type de graphique visé. - 02
Shape your sheet into node, parent and value
Give every row a node name, the name of the node it sits under, and a number. Top level nodes get a blank parent. If your source is a pivot table with only totals, add the missing middle rows yourself: PlotSet cannot infer a level you never wrote down.
- 03
Bring your spreadsheet into PlotSet
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet if you want the rings to update later without a re-upload. PlotSet reads the first row as headers automatically.
La vue données, ici sur un projet de graphique en barres. Importez un CSV, extrayez les chiffres d'une image avec 'Magic Import' ou synchronisez une Google Sheet. Le panneau est identique pour tous les types de graphique. - 04
Map the node, parent and value columns
Confirm which column PlotSet is reading as the node, which as the parent, and which as the value. This usually maps itself correctly when your headers say what they mean, but check it by hand if your sheet carries extra columns PlotSet had to guess between.
Les associations déterminent quelle colonne devient l'étiquette, laquelle fournit les valeurs et laquelle pilote la couleur. 'Auto Binding' les devine à partir de vos en-têtes : vérifiez-les plutôt que de les tenir pour acquises. - 05
Check that children sum to their parent
Before you style anything, scan each branch and confirm its children add up to the number you expect for the parent, or that the parent's value cell is simply blank. A mismatch here is the single most common reason a sunburst chart looks broken once it renders.
- 06
Colour by branch and label what fits
Assign one hue per top level branch and let PlotSet shade its descendants lighter going outward, rather than colouring by depth or leaving the palette random. Turn labels on for rings with room to show them and off for the thin outer ring, where hover tooltips do the job instead.
L'onglet 'Preview' pour un graphique Sunburst Chart. Tous les réglages de style se trouvent dans le panneau entouré en rouge : apparence, en-tête, pied de page et les options propres à ce type de graphique, chacun dans un onglet distinct. - 07
Turn on drill-down for anything past two levels
If your hierarchy runs three or four levels deep, enable click-to-zoom so a reader can click a segment and make it the new centre. Past two levels a static sunburst is hard to read on its own; drill-down is what makes the extra depth usable.
- 08
Publish, embed or export the finished rings
Publish for a live, interactive chart with hover tooltips, drill-down 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 Sunburst Chart avec des données d'exemple déjà chargées, puis remplacez-les par les vôtres.
Ouvrir le modèlePublier, intégrer ou exporter
La 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.
Share : lien public et code d'intégration
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.
Export : SVG, PNG ou JPG
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.
Conseils de style pour un Sunburst Chart
Stop at three levels unless you truly need a fourth
Two or three levels is where a sunburst chart is easiest to read. A fourth level is workable with drill-down turned on; a fourth level on a static export is usually just noise.
Sort each branch's children by value
Within a single parent, order the children largest to smallest before uploading. It gives every ring the same reading direction and makes the size comparison between siblings obvious without labels.
Reserve one colour family per branch
Pick a base hue per top level node and let PlotSet's depth shading handle the rest. Mixing unrelated colours within one branch defeats the one thing colour does for this chart: letting the eye follow a branch outward.
Group small leaves into an explicit "Other"
If a branch has a dozen tiny children and three large ones, roll the tiny ones into a single "Other" node with its own row. It keeps the outer ring legible instead of scattering slivers nobody can click.
Erreurs courantes en créant un Sunburst Chart
Rings show a gap or an overlapping seam
This means a parent's arcs do not add up to that parent's own value, whether it was typed by hand or the children are missing a row. Sum the children yourself against the parent's number, fix the mismatched row, and leave the parent's value cell blank going forward so PlotSet computes it.
The whole chart is one flat colour, or every segment is a different one
Both come from the colour mode being set to depth or to a default palette instead of branch. Open the colour settings and switch to colour by branch, which is what keeps a parent and its descendants visually connected as you read outward.
The outer ring is a wall of unreadable slivers
This is almost always too many leaf categories on one branch, sometimes combined with a level that did not need to exist. Roll the smallest leaves into an "Other" node in your source sheet, or turn on drill-down so the reader can zoom into one branch at a time instead of seeing all of them at once.
En savoir plus sur le Sunburst Chart
Vous n'êtes pas sûr que le Sunburst Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Sunburst Chart : questions fréquentes
Three columns: a node name, its parent's name, and a value. Top level nodes leave the parent blank, and every other row's parent must match another row's node name exactly. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Créez votre Sunburst Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.