Exemple de CSV
| Month | Organic Search | Paid Search | Direct | Referral |
|---|---|---|---|---|
| Jan | 12400 | 3200 | 5100 | 1800 |
| Feb | 13100 | 3450 | 5300 | 1750 |
| Mar | 14200 | 3600 | 5250 | 2000 |
| Apr | 15800 | 4100 | 5400 | 2100 |
| May | 16500 | 4300 | 5600 | 2050 |
| Jun | 17900 | 4550 | 5800 | 2200 |
How to Create an Area Chart
A walkthrough for turning a spreadsheet of values over time into a published area chart in PlotSet, from shaping the columns to styling the fill and exporting the result.
Environ 8 minutesThis walkthrough covers how to create an area chart in PlotSet, moving from a spreadsheet of values over time to a published, interactive chart you can embed or export. You'll finish with the fill styled on purpose (stacked, overlapping, or a single band), a baseline that actually sits at zero, and series names that mean something in the legend, not a screenshot of someone else's example.
If your data is already one time column plus one or two measure columns, this takes about eight minutes. Add a few more if you're deciding between stacked and percentage mode, or if your source export needs reshaping from long to wide first. Budget the eight minutes below and treat the rest as buffer.
Les données dont vous avez besoin
One row per time point, one column per series: a date or period label first, one number per series after it. No merged cells, one header row.
Keep the date column as an actual date, not text. If a spreadsheet stores "Jan" as a plain string, PlotSet spaces the points evenly instead of by the real gap between them.
This is wide format: one column per series. If your source data is long format, a category column and a value column with one row per date and series, pivot it in your spreadsheet tool first, or the series won't split into separate bands.
Blank cells in a measure column render as a gap in that band rather than being skipped. Fill them with zero or the last known value, whichever matches what actually happened during that period.
Keep header names short. They become the series names in the legend and in the hover tooltip, so a column called "Organic Search Sessions (All Devices)" will crowd both.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 01
Open the area chart template
From the PlotSet dashboard, start a new project and choose the Area Chart template. It loads with sample data already bound, so you can see how the time column and the measure columns map onto filled bands 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 with time in the first column
One row per period, with the date or time label first and one column per series after it. If your source is long format, one row per date and category rather than one row per date, pivot it into wide format before uploading.
- 03
Upload the file or connect a live sheet
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 chart 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
Map the time column and your measures
Confirm which column feeds the x-axis and which numeric columns feed the bands. If the points along the axis look evenly spaced even though your periods aren't, the date column is likely being read as text rather than a date.
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
Choose stacked, percentage or overlapping
Stack the series when the running total matters. Switch to percentage stacking when only the changing mix matters and the total would be a distraction. Reach for overlapping only with two or three series and real transparency on the fill.
- 06
Set the stacking order and pick colours
Drag the series order so the one you most want understood sits at the bottom, since only the bottom band has a flat baseline to read against. Give each series its own colour; a repeated colour from the default palette makes two bands look like one.
L'onglet 'Preview' pour un graphique Area 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
Check the baseline and add a title
Confirm the value axis starts at zero. It should, because the fill is measured from there and a truncated axis on an area chart fills in a shape that doesn't exist. Add a title that says what's accumulating, not just the metric name.
- 08
Publish, embed or export the chart
Publish for a live, interactive chart with hover tooltips that show every series at a given date, grab the embed code to drop it into a page, or export a PNG, SVG or PDF for a deck.
Partez du modèle Area 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 Area Chart
Put the series you most need read at the bottom
In a stacked area chart, only the bottom band sits on a flat baseline. Every band above it is judged against a wavy line, which the eye does badly, so the bottom slot should go to the series your reader most needs to track accurately.
Never move the baseline off zero
The filled region is measured from the baseline, so shifting it exaggerates or hides volume that isn't real. If you want to zoom in on a narrow range, turn on value labels and hover tooltips instead of touching the axis.
Cap stacked bands at four or five
Past that, the bands in the middle get thin, wavy and impossible to compare. Group the smaller series into an "Other" band and name it in the legend rather than letting six or seven colours fight for space.
Say so when you switch to percentage mode
A 100% stacked area looks perfectly stable even if the underlying total collapsed. Label the axis and add a line in the caption noting that the chart shows mix, not magnitude.
Erreurs courantes en créant un Area Chart
The x-axis spaces every point evenly, even though your periods aren't
This means the time column is being read as text rather than a date, so PlotSet is placing the labels in order rather than by calendar distance. Reformat the column as an actual date in your source sheet and re-map it.
The bands overlap into one muddy colour instead of stacking
Check two things: the chart's stacking mode may still be set to overlapping, and your data may still be in long format with one series column instead of one column per series. Switch the mode to stacked and confirm each series has its own column.
A stray total row shows up as a spike at the end of the chart
A "Total" or "Average" row left at the bottom of the sheet gets read as an extra time point, not a summary, and appears as an odd extra point past your real data. Delete it from the source file or remove the row in PlotSet's data table before publishing.
En savoir plus sur le Area Chart
Vous n'êtes pas sûr que le Area Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Area Chart : questions fréquentes
Wide format, with one header row: a date or period label in the first column and one number per series in the columns after it. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Créez votre Area Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.