Lesson 1 of 7 · 12 min
Time series plots
Recognise time series data, construct a time series plot with time on the horizontal axis, and read values and changes from it.
What you will be able to do
- Recognise a time series as values of one variable recorded at equal time intervals.
- Construct a time series plot by hand or with a spreadsheet.
- Read values, highs, lows and changes from a time series plot.
A holiday park on the Sunshine Coast records how many guest nights it sells every quarter. The manager wants to know: is business growing? Which quarter should she hire extra cleaners for? How many guest nights should she plan for next summer?
All three questions are about how one variable changes over time. Data like this is a time series, and the first step in answering any question about it is to draw it.
Definition
Time series
A time series is a set of values of one variable recorded at equal intervals of time — every day, week, month, quarter or year — and listed in time order.
Time is not just another variable here. It sets the order of the data, and it always goes on the horizontal axis.
| Year | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| 2022 | 38 | 21 | 29 | 32 |
| 2023 | 41 | 23 | 31 | 35 |
| 2024 | 44 | 24 | 34 | 38 |
Constructing a time series plot
Put time on the horizontal axis
Space the periods evenly and in order. It often helps to number them from the first period (here is Q1 2022 and is Q4 2024).
Put the variable on the vertical axis
Choose a scale that covers the smallest and largest values, and label the axis with the units: guest nights (thousands).
Plot each value in time order
Join consecutive points with straight line segments
The joins make the movement from one period to the next easy to see. They don't claim anything about values between the periods.
Add a title and label both axes
Quarterly guest nights, (Q1 2022) to (Q4 2024). Every Q1 is a peak, every Q2 a low point, and each year sits a little higher than the last.
Which of these data sets is a time series?
Point at the graph (or use the arrow keys) to read each quarter. Compare the three Q1 values, then the three Q2 values. What do you notice?
Reading a time series plot is mostly about comparisons. Compare neighbouring periods to see short-term changes. Compare the same season in different years — Q1 2022, Q1 2023, Q1 2024 — to see long-term growth without the seasonal swing getting in the way.
By how many thousand guest nights did the Q1 figure increase from 2022 to 2024?
Worked example
Construct and read a time series plot of show attendance
A regional agricultural show in Queensland recorded its total attendance each year. Data are illustrative.
| Year | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Attendance ('000) | 43.5 | 42.8 | 45.9 | 47.1 | 46.4 | 49.3 | 18.2 | 47.6 | 50.8 | 52.3 | 51.9 |
a) Construct a time series plot of the data.
b) Use the plot to comment on attendance in 2020.
Annual attendance at the show, 2014–2024.
Step 1: Choose the axes
Time (year) goes on the horizontal axis, one evenly spaced mark per year from 2014 to 2024. Attendance (thousands) goes on the vertical axis.
Time always goes on the horizontal axis of a time series plot, because it orders the data.
Step 2: Choose a vertical scale
The values run from 18.2 to 52.3 thousand, so a scale from 0 to 60 in steps of 10 covers them all.
Step 3: Plot the points and join them in order
Plot each year's attendance, then join each point to the next with a straight line segment. Add axis labels and a title.
The segments show the movement from one year to the next. Without them the pattern is much harder to read.
Step 4: Read the plot
Apart from 2020, attendance rises gradually from about 43 thousand to about 52 thousand. In 2020 it drops to 18.2 thousand, then recovers to 47.6 thousand in 2021.
Step 5: Comment on 2020
2020 is an outlier: a large, one-off irregular fluctuation. A likely cause is the restrictions on public events during the COVID-19 pandemic. It is not part of the trend.
Try it yourself first, then check the working one step at a time.
Answer
The plot (shown) has years on the horizontal axis and attendance on the vertical axis, with the points joined in order. Attendance generally increases, but 2020 (18.2 thousand) is an outlier — a one-off drop, most likely due to pandemic restrictions — after which attendance returns to its trend.
Method
Time on the horizontal axis, evenly spaced; the variable on the vertical axis with units.
Plot every value and join consecutive points with straight segments.
Read the overall direction, then look for values that break the pattern.
Watch out for
Drawing a column graph or leaving the points unjoined.
Treating 2020 as the start of a decreasing trend. One extreme value with a one-off cause is an outlier.
Tip
With a spreadsheet
Type the periods in column A (or just ) and the values in column B. Select both columns and insert a line chart with markers (not a column chart or a scatter chart without lines). Add axis titles and a chart title. A spreadsheet always spaces the periods evenly, which is what you want.
Common mistake
Uneven spacing and missing periods
Every period gets the same horizontal space, even if a period's value is missing — leave a gap rather than closing it up. Squashing periods together, or plotting years such as 2014, 2016, 2021 at equal spacing, distorts how fast the series changes.
In the holiday park plot, which quarter has the fewest guest nights in every year?
Summary
A time series is one variable recorded at equal time intervals, in time order.
A time series plot has time on the horizontal axis (evenly spaced) and the points joined in order by straight line segments.
Number the periods from the first one; you'll need for trend lines later.
Compare neighbouring periods for short-term change, and the same season across years for long-term change.
Finished the lesson?
Try the 3 quick checks above and the lesson completes itself, or mark it complete now.