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)
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.
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.
| Time | Value |
|---|---|
| 2026-01-01 | 30 |
| 2026-02-01 | 34 |
| 2026-03-01 | 38 |
