Change over time
Spiral time-series chart
Wraps time around a spiral so recurring cycles can be compared across turns.
- Chart
- Seasonality
- Trend over time
What it answers
Do patterns recur at the same point in each cycle?
- Shape
- Spiral path or spiral cells
- What it shows
- Recurring cycles and phase shifts.
Example
The question
Does demand peak at the same point every year?
Monthly demand 2023 to 2025 on a spiral, one turn per year
Illustrative data. It belongs to no company.
When to use it
Use it when
Exploring cyclic patterns over repeated periods.
Avoid it when
When precise chronological lookup or accessible linear reading is primary.
How to read it
Follow time around turns and compare matching angular positions.
Note
Define cycle length and radial progression.
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
- Define the cyclic period, map time to angle and successive cycles to radius, and retain clear chronological labels.
- 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 Jan 2025=30, Jan 2026=38. Place both at the January angle on successive turns. The second value is larger.
| Time | Value |
|---|---|
| 2026-01-01 | 30 |
| 2026-02-01 | 34 |
| 2026-03-01 | 38 |
