Exemple de CSV
| Quarter | North America | Europe | APAC |
|---|---|---|---|
| 2023-Q1 | 182000 | 146000 | 98000 |
| 2023-Q2 | 191000 | 151000 | 104000 |
| 2023-Q3 | 205000 | 158000 | 112000 |
| 2023-Q4 | 224000 | 167000 | 121000 |
| 2024-Q1 | 218000 | 171000 | 129000 |
| 2024-Q2 | 233000 | 179000 | 138000 |
How to Create a Line Chart
A step by step walkthrough for turning a spreadsheet of dates and numbers into a published line chart in PlotSet, from shaping the sheet to exporting or embedding the finished trend.
Environ 8 minutesThis is how to create a line chart in PlotSet that actually reads as a trend and not just a wiggly shape: your own dates in the first column, one or more series after it, styled and published the same way any real chart goes out. By the end you will have taken one time series from a raw spreadsheet to a published, embeddable chart with hover tooltips, not a copy of someone else's example with your numbers swapped in.
If your sheet already has one date column and one or two number columns in order, this takes about eight minutes. Add another five if you are converting a wide report, one column per month, into the long, one-row-per-period shape a line chart wants, or if you need to decide how a genuine gap in the series should be handled before you upload.
Les données dont vous avez besoin
One row per time period, already in chronological order: the date or period label first, then one numeric column for each line you want on the chart.
Keep the time column consistent: real dates, or a fixed label pattern like "2024-Q1" throughout. A column that mixes "Q1 2024" with "01/2024" sorts as text, not as time, and the axis will follow whatever order the rows happen to be in.
One numeric column per line. Three columns of regional revenue, like the sample above, become three lines with no extra configuration once they are mapped.
Rows must already be sorted oldest to newest before you upload. PlotSet draws the time axis in row order, it does not resort a date column for you.
Leave a cell blank for a period a series genuinely has no reading for. A blank draws as a gap in that one line rather than dropping to zero, which is usually what you want; fill it in if it is simply a missing entry, not an absence.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 01
Open the Line Chart template
From the PlotSet dashboard, start a new project and choose the Line Chart template. It loads with sample data already bound to it, so you can see the exact column layout, one date column followed by one or more series columns, 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 a time column plus series columns
Put your date or period in the first column, in order, and one number column per line after it. If your source is a wide report with a column per month, transpose it first: the upload needs one row per period, not one column per period.
- 03
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 you want the chart to pick up new periods later without a re-upload. PlotSet reads the first row as your column headers.
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 confirm your series
Tell PlotSet which column is the time axis and check that every numeric column you meant to plot is picked up as a series. This is usually automatic with clean headers, but worth a manual check if your sheet carries an extra column, like a running total, you don't want plotted.
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
Label the lines directly, skip the legend
Turn on end-of-line labels so each series name sits at the end of its own line instead of in a separate legend box. On anything with more than one line, this removes the colour-matching step entirely and is the single biggest readability change you can make.
L'onglet 'Preview' pour un graphique Line 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. - 06
Set the value axis range on purpose
Decide whether the axis should start at zero or zoom into the range where the real movement happens. A line chart does not need a zero baseline the way a bar chart does, so pick a range that reflects the actual variation and say so if you are deliberately zooming in.
- 07
Turn markers and gridlines on only if the data is sparse
With monthly or quarterly data, individual point markers and background gridlines usually just add clutter to a shape that is already clear. Turn markers on only if readings are infrequent enough that each one is worth calling out on its own.
- 08
Publish, embed or export
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 or report.
Partez du modèle Line 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 Line Chart
Direct labels beat a legend almost every time
Once you have more than one line, a legend forces the reader to match colours between a box and the chart. A label at the end of each line answers the question before it gets asked, and it scales fine down to about five series.
Cap it at five lines, then split or highlight
Past roughly five series a line chart turns into a tangle nobody can trace. If you genuinely have more, either build small multiples, one line per small chart on shared axes, or colour the one line that matters and grey out the rest.
Do not mix units on one axis
Revenue in dollars and a percentage plotted on the same vertical scale will squash one of them flat. If you need to compare series in different units, index them to a common starting point (100 at the first period, for instance) or put them on separate charts.
Break the line over real gaps, do not smooth across them
If a series is missing a reading for one period, leave that cell blank so PlotSet breaks the line rather than drawing a straight guess across the gap. Curve smoothing is worth avoiding for the same reason: it can invent a peak or a dip between two points that were never actually measured.
Erreurs courantes en créant un Line Chart
The line zigzags instead of trending smoothly
This almost always means the source rows are not sorted chronologically before upload, so PlotSet is drawing the axis in whatever order the sheet happened to have. Sort the time column oldest to newest in your spreadsheet and re-upload.
One line sits flat along the bottom while another dominates the chart
Check whether the two series are actually in the same unit. A series in the thousands plotted against one in single digits, or dollars against a percentage, will always compress the smaller one to a flat line near zero. Normalise both to a common scale or split them into separate charts.
A period with no real reading shows as a straight diagonal jump
That happens when the missing cell was filled with a zero or an average instead of left blank. Clear the cell in the source sheet so it is genuinely empty, then re-upload: PlotSet will break the line there instead of drawing a fake slope across it.
En savoir plus sur le Line Chart
Vous n'êtes pas sûr que le Line Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Line Chart : questions fréquentes
One row per time period, sorted oldest to newest, with the date or period label in the first column and one numeric column for each line you want. CSV, .xlsx and a pasted spreadsheet range all work, as long as the time column stays in one consistent format.
Créez votre Line Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.