Exemple de CSV
| Channel | Budget |
|---|---|
| Paid Search | 42000 |
| Social Ads | 31000 |
| 18500 | |
| Content | 12000 |
| Events | 9500 |
| Other | 6000 |
How to Create a Donut Chart
A step by step walkthrough for turning a spreadsheet into a published donut chart in PlotSet, from shaping the sheet to filling the centre hole and exporting or embedding the finished ring.
Environ 7 minutesA marketing budget split across five channels, paid search, social ads, email, content and events, with one honest "Other" row for the rest, is the working example for how to create a donut chart in PlotSet. By the end you'll have a published, interactive ring chart with the total budget sitting in the centre hole, built from your own categories, not a screenshot of someone else's.
If your spreadsheet is already two columns, category and value, this takes about seven minutes. Add a few more if you're pulling the numbers out of a wider report, or if you're still deciding what belongs in "Other". Budget the walkthrough below and treat the rest as buffer.
Les données dont vous avez besoin
Two columns, one row per category: the category name first, its raw value second. No totals row, one header row, and categories that genuinely add up to the whole you're describing.
Keep the value column as raw numbers, not percentages you've already worked out. PlotSet calculates each segment's share of the total itself, so a percent sign in that column throws the math off.
Roll anything under a few percent of the total into a single "Other" row before you upload. Eight thin slivers read worse than one clearly labelled bucket.
Delete a totals row before uploading, the same rule as any summed chart. Uploaded as data, a "Total" row becomes its own segment, usually the biggest one on the ring.
Category names need to be unique. Two rows both labelled "Misc" or "Other" get merged or duplicated depending on your spreadsheet's export, so rename one before you upload.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 01
Open the donut chart template
From the PlotSet dashboard, start a new project and pick the Donut Chart template. It loads with sample data already in place, so you can see the two-column shape it expects before touching 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 two columns
Category name in the first column, its number in the second, one row per category. If you're working from a pivot table, flatten it first: the upload should be nothing but categories and values, no subtotals mixed in.
- 03
Import your data or connect a sheet
Import a CSV or .xlsx from the data panel, paste rows straight from a spreadsheet, or connect a Google Sheet if you want the ring to refresh 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
Point PlotSet at the category and value columns
Confirm which column feeds the segment labels and which feeds the angles. PlotSet usually guesses right when your headers are clear, but check it manually if the sheet carries extra columns it might have picked up by mistake.
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
Order the segments and switch on percentage labels
Sort largest to smallest so the eye has a path around the ring instead of hunting for it. Turn on percentage labels directly on each segment: angles alone are hard to judge, and the number removes the guesswork.
- 06
Put the total in the centre hole
Set the centre text to the sum of your value column, not a default label PlotSet might have picked. This is the one thing a donut can do that a pie can't, so it's worth checking rather than leaving on auto.
- 07
Pick a colour set and a title
Use shades of one hue for a ranked set of related categories, or distinct colours only when the categories are genuinely different things. Reserve a stand-out colour for the one segment you want to highlight. Give the chart a title that states what's being split, not just the word "budget".
L'onglet 'Preview' pour un graphique Donut 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. - 08
Publish, embed or export the ring
Publish for a live, interactive ring with hover tooltips and a shareable link, grab the embed code for a page, or export a PNG, SVG or PDF if you need a static image for a deck or report.
Partez du modèle Donut 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 Donut Chart
Keep the hole wide enough to read
A thin ring with a cramped centre makes the total illegible and the segments hard to click. Widen the hole until the centre number sits comfortably on its own line, with a small caption underneath naming what it is.
Label segments directly once you're under six
With five categories or fewer, put the label and percentage right on or beside each arc and drop the separate legend. It removes the lookup step between colour and category entirely, which a legend never quite avoids.
Match colour intensity to size, not to preference
For a ranked breakdown, ordering shades from darkest (largest share) to lightest (smallest) reinforces the sort visually. Save a genuinely different colour for a category you're calling out on purpose, like this year's new channel.
Round the centre number to something readable
A centre total of $118,517.42 is precision nobody needs at a glance. Round to a sensible unit ($119K, or 42%) and let the data table underneath carry the exact figure for anyone who wants it.
Erreurs courantes en créant un Donut Chart
The ring doesn't visually read as a full 100%
This usually means two categories overlap, or one is a rate or an average rather than a slice of the same total. Check your source data for a row that doesn't belong to the same whole as the rest, and pull it into its own chart if it doesn't.
Small segments overlap their own labels
Below a few percent, a label has nowhere to sit without colliding with its neighbour. Roll those rows into a single "Other" category before upload rather than fighting label placement after the fact.
The centre shows the wrong number
Left on its default, the centre sometimes displays a segment count or the largest value instead of the total you want. Open the centre text setting and point it at the sum explicitly, then re-check it after any edit to the underlying rows.
En savoir plus sur le Donut Chart
Vous n'êtes pas sûr que le Donut Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Donut Chart : questions fréquentes
Two columns and one header row: category names in the first column, one raw number per category in the second. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too. Don't pre-calculate percentages; PlotSet does that from the raw values.
Créez votre Donut Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.