Exemple de CSV
| Service | Monthly Spend ($) |
|---|---|
| Compute | 4200 |
| Storage | 1350 |
| Database | 980 |
| Networking | 610 |
| Support | 340 |
How to Create a Pie Chart
A step by step walkthrough for turning a spreadsheet into a published pie chart in PlotSet, from shaping the sheet and rolling up the long tail to exporting or embedding the finished chart.
Environ 6 minutesSwap in your own numbers instead of the sample data the template loads with, and here's how to create a pie chart in PlotSet from a label column, a value column, and a total the slices actually add up to. You will upload the sheet, roll any long tail of small categories into a named group, order the slices so the biggest lands first, and publish something you can embed or hand off as an image.
With a clean two column sheet of five or six categories, this takes about six minutes end to end. Add a few more if your source is a wider report you need to trim down first, or if you are deciding what to do with a dozen tiny categories that do not deserve their own slice.
Les données dont vous avez besoin
Two columns, one row per category: the label first, the number second. The numbers should sum to one meaningful total, and there should be no more than six or seven rows by the time you upload.
The value column needs to be a plain number, not a pre-formatted percentage string like "38%". PlotSet calculates the percentage from the raw values, so let it do that math.
If your source report has fifteen or twenty rows, decide the cutoff in the spreadsheet first. Sum everything below it into one row labelled "Other" rather than uploading all of it and grouping later.
One header row only. A totals row at the bottom gets read as its own slice, usually the largest one, and it will swallow the rest of the circle.
Negative numbers and zeros do not have a sensible angle in a pie. Filter zero rows out and rethink the chart type if any value is negative.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 01
Choose the Pie Chart template
From the PlotSet dashboard, start a new project and choose the Pie Chart template. It loads with sample data already bound to it, so you can see the two column shape it expects before you bring in 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 a label and a value column
Put the category name in the first column and its number in the second, one row per category. If the source is a pivot table or a finance export, strip out subtotal rows before you get near PlotSet.
- 03
Roll the long tail into Other, before uploading
If you are looking at more than six or seven categories, sum the smallest ones into a single row labelled "Other" in the spreadsheet itself. Doing this before upload keeps your source file honest about what the chart is actually showing.
- 04
Upload your file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows straight from a spreadsheet, or connect a Google Sheet if the underlying numbers change on a schedule and you want the chart to pick that up.
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. - 05
Map the label and value columns
Confirm which column feeds the slice labels and which feeds the angles. PlotSet usually gets this right when your headers are clear, but check it manually if the sheet has extra columns it might have guessed at.
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. - 06
Sort the slices and turn on percentage labels
Order slices largest to smallest starting at twelve o'clock, unless the categories carry their own order (age bands, survey scale). Then switch on percentage labels for every slice: angles alone are not precise enough for a reader to compare, the numbers are.
- 07
Set a colour per slice and drop the legend if you can
Give each slice its own distinct colour rather than shades of one hue, which read as ranked when they are not. With five slices or fewer, label each one directly on the chart and remove the legend entirely: it saves the reader a lookup.
L'onglet 'Preview' pour un graphique Pie 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 finished chart
Publish for a live, interactive chart 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.
Partez du modèle Pie 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 Pie Chart
Label slices directly, skip the legend under six categories
A legend forces the reader to look away from the circle, find a colour, then look back. Direct labels on or beside each slice remove that round trip entirely, and PlotSet fits them cleanly up to about five or six slices.
Start at twelve o'clock, go clockwise, biggest first
This is the reading convention people already know, so use it rather than fighting it. The moment the largest slice starts anywhere else, readers spend a second just orienting themselves before they get to the data.
Name the Other slice in the title or a caption
"Other" on its own tells the reader nothing about what got grouped. A short caption, "Other includes eleven regions under 2% each", turns a vague catch-all into an honest summary.
Keep the palette flat, no gradients or 3D shading
A gradient or a tilted 3D slice implies an extra dimension of meaning that is not there, and it distorts the angle a flat pie relies on to be read correctly. One flat colour per slice is the whole job.
Erreurs courantes en créant un Pie Chart
The slices do not add up to a sensible whole
This usually means a filter or a date range excluded some rows before upload, so the circle claims completeness it does not have. Check the raw row count in PlotSet's data table against your source sheet and reconcile the difference before publishing.
Colours jump around every time you resort
If colour is assigned by row position rather than by category name, resorting the slices reshuffles the palette too. Assign colours to the category labels themselves in the style panel, not to whatever sits in row three at the time.
Too many thin, unlabeled slivers around the edge
A raw export with twenty countries or product SKUs produces a dozen slices too thin to carry a label. Go back to the spreadsheet, not the chart settings, and collapse everything under your cutoff into one Other row.
En savoir plus sur le Pie Chart
Vous n'êtes pas sûr que le Pie Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Pie Chart : questions fréquentes
Two columns and one header row: a category label in the first column, one plain number per category in the second. CSV and .xlsx both work, and the numbers should be raw values, not pre-formatted percentages, since PlotSet calculates the share itself.
Créez votre Pie Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.