Skip to content

MODULE 4 · LESSON 21 · Data visualization

Line charts

Represent change across an ordered variable without implying unsupported continuity or precision.

By Laurence Svekis · Self-paced · All worked data is synthetic unless you supply your own source.

Try the practice ↓

PredictInspectCalculateCheckExplainTransfer

Your starting point

Prerequisites: Use the ideas and vocabulary from lesson 20; revisit its worked examples if needed.

Definition: A line chart connects values in an ordered sequence, commonly time. The connecting segments emphasize change between observations; they do not prove that every intermediate value was measured or that the process changed smoothly.

Check the time axis first

Use consistent dates and meaningful intervals. Sorting date labels as arbitrary text can put months in the wrong order. The academy sorts ISO dates lexically, which matches chronological order for that format. It plots observations at equal visual steps, so use equal time intervals for a conventional line interpretation; irregular gaps need explicit explanation or a numerical time axis.

Distinguish missing from zero

A missing month is not a month with no activity. Connecting observations across a gap can suggest a smooth path that was never observed. Record missing periods and explain the gap rather than silently inserting zero. Also distinguish cumulative totals from period totals: a cumulative series tends to rise even when the underlying monthly activity is declining.

Avoid reading causality from timing

An increase after a campaign can be a useful clue, but other changes may have occurred at the same time. Seasonality, reporting definitions and group composition can affect the line. Label the period and unit, compare a relevant baseline and state whether the data support only a descriptive trend. Forecasting beyond the observed range adds assumptions that a connecting line does not justify.

Two worked examples

Period totals

Monthly sessions are January 100, February 120 and March 90. A line of period totals rises and then falls. Cumulative totals are 100, 220 and 310, which rise throughout. A statement that activity increased every month would be unsupported if based only on the cumulative chart.

A missing interval

January revenue is 80 and March revenue is 120, while February is unrecorded. A straight segment visually suggests an intermediate value of 100, but that number was not observed. Preserve the missingness in your explanation and obtain the missing record before claiming a steady monthly increase.

Where this becomes useful

A project manager tracks completed tasks each week. Changes in team size, task complexity or the definition of done can alter the series. A trend description should mention such changes before suggesting a process improvement caused the increase.

Make an attempt

Use the workbench with Monthly budgets. Filter to one category, use month on the x axis and actual spending on the y axis, then choose Line. Inspect chronological order and explain whether each point is a period value or an accumulated total.

Open the accompanying interactive lab →

Misconception check

Claim: A rising cumulative line proves the underlying activity is accelerating.

Inspect the correction

Cumulative totals can rise while period activity falls. Inspect period values and the intended comparison.

Independent application

Create a six-period synthetic series and its cumulative version. Plot both with clear labels, introduce one missing period, and write a trend summary that distinguishes observed changes, cumulative arithmetic and unobserved intervals.

Completion records practice and self-review. It is not certification of statistical competence.