Change over time

Smoothed line chart

Shows an interpolated or statistically smoothed path through or near measurements.

  • Chart
  • Trend over time
  • Relationship

What it answers

What broad pattern does the smoothed path suggest?

Shape
Curved line
What it shows
Broad direction or nonlinear form.

Example

The question

What is the general shape of energy use through a working day?

Average electricity use by hour, office building (kWh)

Average electricity use by hour, office building (kWh)Smoothed curve. Low overnight at about 40, rising from 06 to a peak of about 120 around 14, falling in the evening.kWh per hour04080120160000204060810121416182022Hour of day
Average electricity use by hour, office building (kWh)Smoothed curve. Low overnight at about 40, rising from 06 to a peak of about 120 around 14, falling in the evening.kWh per hour04080120160000408121620Hour of day
Smoothed curve. Low overnight at about 40, rising from 06 to a peak of about 120 around 14, falling in the evening.

Illustrative data. It belongs to no company.

When to use it

Use it when

Reducing visual noise or presenting an appropriate interpolated curve.

Avoid it when

When smoothing could conceal abrupt changes or imply unsupported values.

How to read it

Read the fitted curve and compare it with underlying observations where shown.

Note

Interpolation and statistical smoothing are different operations.

The data you need

Layout
Long table
Fields
Time: date/datetime or ordered number; Value: number
One row is
One observation at a time or ordered position. What is the grain?
Rules
Parse dates consistently and sort ascending. Resolve duplicate timestamps by a declared rule. Missing values are not automatically zero.
Optional
Optional Series. Use regular spacing for methods requiring it.
Preparation
Choose interpolation or a statistical smoother explicitly. Retain measured points and avoid unsupported extrapolation.
Units
Time uses a stated date/time unit and sampling period; the value axis uses the measure's unit. Rates need their own explicit denominator.
Example of the input layout: Long tableA long table: one row per observation, few columns. New data adds rows.TimeValueAABBC
A long table: one row per observation, few columns. New data adds rows.

Worked example

Data X=1,2,3; Y=10,15,11. A smooth curve suggests a mid-range peak. The three observed points remain visible.

TimeValue
2026-01-0130
2026-02-0134
2026-03-0138