How to do trend analysis in Excel
Trend analysis answers two questions: which way are the numbers heading, and how fast? Excel can fit a trendline, give you the slope, and project it forward. Here's how to do it honestly, and the one-click alternative.
When trend analysis earns its keep
Single numbers tell you where you are. A trend tells you where you're going — and how quickly.
Is it growing?
Strip the month-to-month noise and see the real direction.
How fast?
The slope tells you the average change per period.
Where next?
Extend the trend to a rough, honest projection.
How to do it in Excel
A trendline plus a couple of functions gets you direction, pace and a first-pass forecast.
Order your data by time
Periods in the first column, the metric in the next, oldest to newest.
Add a trendline
Make a line or scatter chart, click the series, then Chart Elements (+) › Trendline. Tick Display Equation and R-squared.
Read slope & fit
The equation's slope is change per period; R² shows how well the line fits. Or compute it directly with =SLOPE(y, x) and =TREND(...).
Project carefully
Use =FORECAST.LINEAR(new_x, y, x) to extend — and only as far as the pattern can reasonably hold.
Trend analysis is easy to abuse. A straight trendline assumes the future looks like the past, and R² can look high on data that is actually seasonal or curving. Always eyeball the series first: if it has repeating cycles, a plain linear trend will mislead, and a seasonal method like FORECAST.ETS or Holt-Winters fits far better.
The faster way — skip the setup
A trendline is quick to draw and easy to over-trust. DataHub Pro checks the fit, spots seasonality and forecasts with a range.
Easy to over-trust
- Add and read the trendline
- Pull slope and R² by hand
- Decide if linear even fits
- Switch methods for seasonal data
Trend, fit and forecast
- Upload the series — trend and slope computed
- Seasonality detected automatically
- Forecast with confidence range
- Straight into a board-ready report
FAQ
How do I do trend analysis in Excel?
Order your data by time, chart it, then add a trendline from Chart Elements and display its equation and R-squared. The slope is the average change per period; you can project forward with FORECAST.LINEAR.
What does the slope of a trendline mean?
The slope is how much the metric changes, on average, for each step in time — a slope of 250 on a monthly series means roughly +250 per month. You can get it directly with =SLOPE(y_values, x_values).
When is a linear trendline the wrong choice?
When the data is seasonal or curving. A straight line will hide repeating cycles and can show a misleadingly high R². For seasonal series use FORECAST.ETS or a Holt-Winters method instead.
Keep exploring
More visual analysis you can run on your own data — no sign-up needed to read.
See the trend, not the noise
Upload your time series and DataHub Pro fits the trend, checks for seasonality and forecasts forward for you. Free to try, no card.
Start free →