How to Visualize Trends Over Time

Written by Chart Maker Hub · Published November 12, 2026 · 3 min read

Time-series data, meaning values recorded at regular intervals, is the most common data in reports. The right chart depends on what you want readers to notice: the direction, the total, the mix, or the moment something happened.

Pick the chart from the question

You want to show…	Use
Direction and rate of change	Line graph
A total and how its parts contribute over time	Stacked area chart
How the mix shifts, regardless of total	100% stacked area chart or stacked bars
Two measures with different units (revenue and margin)	Combination chart with a second axis
A few discrete periods (four quarters)	Bar graph
Events and milestones rather than values	Timeline

Lines for many periods, bars for a few

A line implies continuity between points, so it suits regular measurements such as months or days. With only a handful of periods, or values that are separate totals such as annual budgets, bars are easier to read and label.

Compare growth with an index

When series have very different sizes, the larger one flattens the smaller one. Indexing fixes this: divide every value by the series’ first value and multiply by 100. Each line then starts at 100 and shows relative growth.

Year	Product A revenue	Product B revenue	A (index)	B (index)
2021	200	20	100	100
2022	220	24	110	120
2023	250	30	125	150
2024	240	33	120	165
2025	290	40	145	200

Indexing puts both products on the same scale, revealing that the smaller one doubled.

Say clearly in the subtitle that the chart is indexed and which period equals 100.

Smooth noisy data with a moving average

Daily or weekly data is often too jagged to show a trend. A moving average replaces each point with the average of the last few points. For monthly values 12, 15, 11, 18, 14 and 20, a 3-month moving average gives 12.7, 14.7, 14.3 and 17.3 for months three to six. Calculate it in your spreadsheet, add it as a second series, and label it so readers know it is smoothed.

Show the parts with a stacked area chart

When the total and its components both matter, stack the series. The top edge is the total; each band is one part. Put the most stable series at the bottom so the others aren’t distorted by its changes.

A stacked area chart shows the total and each source’s contribution.

Percent-change pitfalls

Gains and losses aren’t symmetric. A value that rises 50% and then falls 50% ends below where it started: 100 → 150 → 75.
Small bases exaggerate. Going from 2 to 6 is a 200% increase but may mean very little. Show the absolute values too.
Name the comparison. “Up 8%” could mean versus last month or versus the same month last year. Seasonal data usually needs the year-over-year comparison.

Axis and labelling checklist

Keep time on the horizontal axis, oldest on the left, with evenly spaced periods. Leave a missing period blank rather than skipping it.
Line graphs may zoom the y-axis to show change; bar and area charts must start at zero.
Label lines directly or keep the legend in the same order as the lines at the right-hand end.
Use the subtitle for the takeaway, for example “Sales doubled after the spring launch”.
Mark important events, such as a price change, in the subtitle or caption so readers can connect cause and effect.

For step-by-step instructions on building the chart itself, see How to make a line graph.