What Is a Trendline on a Graph? | The Line of Best Fit

A trendline is a line on a chart that reveals the overall direction of data points, helping you identify patterns and forecast future values.

You drop a bunch of data points on a scatter plot — study hours vs. test scores or ad spending vs. sales. The dots go everywhere. Then someone draws one straight line through the mess. That single line is a trendline, and it turns noise into a story.

A trendline (also called a line of best fit) is a mathematical line that minimizes the total distance between itself and every point on the graph. It won’t hit every dot, but it comes as close as possible. This article walks through what trendlines are, the different types you’ll encounter, and how to use them without getting fooled.

What Exactly Is a Trendline?

A trendline is a line superimposed on a chart that highlights an underlying pattern of individual values. The line itself can take many forms depending on the shape of the data — straight, curved, or even wavy. Most software packages can draw one automatically once you select your data range.

The technical name “line of best fit” comes from the math behind it. The line is calculated to minimize the vertical distance from each data point to the line, usually using a method called least squares regression. That means the line represents the best possible summary of the data’s general behavior.

Why “Best Fit” Matters

If you try to connect every dot with a wobbly line, you get a mess that’s too specific to the sample. A trendline sacrifices perfect fit in exchange for a clear, generalizable pattern. That trade-off makes it useful for seeing the forest instead of the trees.

Why You Need a Trendline on Your Graph

Raw data points can look like random noise. A trendline cuts through that noise to show what’s really happening. Here’s what a good trendline reveals:

• Reveals the direction: A positive slope means both variables increase together. A negative slope means one goes up while the other goes down.
• Forecasts future values: Extend the trendline beyond your data and you get a rough prediction of what might happen next.
• Quantifies relationships: The slope tells you how much one variable changes when the other changes by one unit. In a study example, a slope of 15 means each extra study hour typically brings a 15-point test score increase.
• Smoothes fluctuations: A moving average trendline averages recent data points to filter out short-term noise, making long-term patterns pop out.
• Detects outliers: Points that sit far from the trendline stand out visually, flagging unusual data that deserves a closer look.

Without a trendline, you’re left guessing whether the scatter is random or meaningful. With one, you have a measurable summary of the data’s behavior.

Types of Trendlines and When to Use Them

The right trendline depends on the shape of your data. A straight line works when change happens at a consistent rate. When growth accelerates or slows, curved trendlines fit better. The different types of trendlines — linear, exponential, and more — are explained in Storytellingwithdata’s trendline definition article.

Choosing the right type matters. A linear line on exponential data will mislead you. Microsoft’s official guide notes that polynomial trendlines should be used sparingly because they can overfit the data, capturing noise instead of pattern.

How to Interpret a Trendline: Slope and R-Squared

Once you have a trendline, two numbers tell you how strong and meaningful it is. The slope tells you the rate of change; the R-squared tells you how well the line fits the data. Here’s how to read both:

1. Check the slope sign and magnitude. A positive slope means both variables rise together. A negative slope means they move in opposite directions. The number tells you the change in the vertical variable per one-unit change in the horizontal variable. In a Khan Academy example, a slope of 15 means each extra study hour predicts a 15-point higher test score.
2. Evaluate the R-squared value. This number ranges from 0 to 1. The closer it is to 1, the more reliable the trendline. An R-squared of 0.9 means 90% of the variation in your data is explained by the trendline. Graph software can automatically display this value.
3. Look at residuals. Residuals are the vertical gaps between each data point and the trendline. If the residuals form a pattern (like a curve), the linear trendline isn’t the right choice — try a different type.

A high R-squared with a sensible slope gives you confidence in the trend. A low R-squared means the trendline is a weak summary, and you should be cautious about drawing conclusions.

Using Trendlines in the Real World

Trendlines have practical applications across fields. In investing, a trendline drawn across price lows can mark support levels; a line across highs shows resistance. When prices break through these lines, it signals a possible trend change. Per Domo’s trendline chart overview, logarithmic trendlines work when growth slows over time, like a new product whose early rapid adoption tapers off as the market matures.

In technical analysis, trendlines are often paired with moving averages. The moving average confirms the overall trend direction, while the trendline itself can pinpoint exact entry or exit points. Used together, they give a fuller picture of market behavior.

The Bottom Line

Trendlines are essential tools for making sense of data — they transform scattered points into clear stories about direction, strength, and relationships. The key is choosing the right type for your data shape and checking the R-squared so you don’t overinterpret noise. A linear line on exponential growth or a polynomial on random scatter can lead to wrong conclusions.

If you’re building a trendline for a school science project, your math teacher can help confirm whether a linear or curved line best fits your data set — and whether your R-squared supports your conclusion.