What a trend line does and when you need one
A trend line is a straight or curved line that Excel draws through your data points to show the overall direction they are moving. If you have sales numbers climbing month to month, a trend line makes that pattern visible at a glance. If you have test scores scattered across a chart, a trend line shows whether they are generally rising, falling, or flat.
Trend lines work best when you have a scatter chart or a line chart with data that clusters around a pattern. Excel calculates the line mathematically so it sits as close as possible to all your points. You might use a trend line to show a client that revenue is growing, to demonstrate that a process is improving over time, or to forecast what might happen next if the pattern holds.
The trend line itself does not change your data — it is purely visual. You can add it, remove it, or change its style without affecting any of the numbers in your spreadsheet.
Key Takeaways
- Right-click any data point on your chart, select "Add Trend Line", and choose the type that matches your data pattern — linear for straight trends, exponential for rapid growth, polynomial for curves.
- The trend line appears when ready on your chart and you can format it by changing its color, thickness, or line style from the Format Trend Line panel.
- Check the "Display Equation on Chart" box if you want to see the mathematical formula, or "Display R-squared Value" to see how closely the line fits your actual data.
- A trend line works on scatter charts and line charts but not on bar or column charts — if you need one on a bar chart, convert it to a scatter chart first.
How to add a trend line to an existing chart
Start with a chart already on your spreadsheet. Click the chart to select it, then right-click directly on one of the data points (the dots or markers on the line). A menu will appear. Select "Add Trend Line" — it is usually near the top of the menu.
The Format Trend Line panel will open on the right side of your screen. You will see a section called "Trend Line Options" with several choices. The default is "Linear", which draws a straight line. This works for data that climbs or falls at a steady rate. If your data curves upward sharply (like exponential growth), select "Exponential". If it dips and rises (like a wave), select "Polynomial" and choose the degree — 2 for a gentle curve, 3 or higher for more complex shapes.
Once you pick a type, the trend line appears on your chart when ready. You can close the panel or leave it open to adjust the line further.
Formatting the trend line so it stands out
By default, the trend line is thin and blue. You can change how it looks so it is easier to see or matches your chart style. With the Format Trend Line panel still open, look for "Line Color" and "Line Style" options. Click "Line Color" and choose a new color — red or black often stands out better than blue. Click "Line Style" to make the line thicker, thinner, or dashed.
You can also add a label so anyone looking at your chart knows what the line represents. In the Format Trend Line panel, find the "Trend Line Name" section and select "Custom". Type a name like "Sales Growth" or "Temperature Trend". This label will appear in your chart legend.
Showing the equation and fit statistics
If you want to know the exact mathematical formula behind your trend line, check the box for "Display Equation on Chart". The equation will appear as text on the chart itself — it shows the slope and starting point of the line. This is useful if you want to predict future values by plugging in new numbers.
You can also display the R-squared value, which tells you how well the trend line fits your data. An R-squared of 1.0 means the line passes through every point perfectly. An R-squared of 0.8 or higher usually means the line is a good fit. Lower values mean your data is more scattered and the trend line is less reliable for prediction. Check "Display R-squared Value" to see this number on your chart.
Choosing the right trend line type for your data
Linear trend lines work when your data rises or falls at a steady rate — sales increasing by roughly the same amount each month, or temperature dropping consistently over time. If you plot a linear trend line on data that actually curves, the line will not fit well and your R-squared value will be low.
Exponential trend lines fit data that grows or shrinks faster and faster — like a virus spreading, or a population boom. The line curves upward steeply. Polynomial trend lines fit data that has peaks and valleys — like seasonal sales that spike in December and dip in January, or test scores that improve, plateau, then improve again. A polynomial of degree 2 (called a quadratic) creates one curve. Degree 3 creates two curves, and so on.
Power trend lines fit data where one variable depends on another raised to a power — like the relationship between the size of a square and its area. Logarithmic trend lines fit data that rises quickly at first, then levels off — like the effect of advertising spending on sales, where doubling your budget does not double your results.
If you are not sure which type fits best, try linear first. If the R-squared value is below 0.7, try exponential or polynomial and compare their R-squared values. The type with the highest R-squared is the best fit.
Removing or editing a trend line
To remove a trend line, click the chart, then right-click the trend line itself (not a data point). Select "Delete" from the menu. The line disappears but your data stays intact.
To change the trend line type after you have added it, right-click the trend line and select "Format Trend Line". The panel opens again and you can switch to a different type, adjust the color, or change any other setting. You do not have to delete and re-add the line — just edit it in place.
Trend lines on different chart types
Trend lines work on scatter charts and line charts. They do not work on bar charts or column charts — Excel will not let you add one because those chart types do not show continuous data the same way.
If you have a bar or column chart and you want a trend line, convert it to a scatter chart first. Right-click the chart, select "Change Chart Type", and pick "XY (Scatter)". Your data will reorganize into a scatter plot. Then add the trend line as usual. Keep in mind that a scatter chart displays data differently than a bar chart, so the visual appearance will change.
Frequently Asked Questions
Can I add multiple trend lines to the same chart?
Yes. Right-click each data series separately and add a trend line to each one. If you have sales data for two different products on the same chart, you can add a linear trend line to one product and an exponential trend line to the other. Each trend line will have its own color and equation.
What does R-squared tell me about my data?
R-squared measures how closely your trend line matches your actual data points. A value of 1.0 means perfect fit. A value of 0.8 or higher usually means the trend line is reliable. Below 0.5 means the line does not represent your data well and you should try a different trend line type.
Can I use the trend line equation to predict future values?
Yes, if the R-squared value is high (0.8 or above). The equation shows the relationship between your variables. Plug in a future time period or value on the left side of the equation and solve for the predicted result. Keep in mind that predictions assume the pattern will continue, which is not always true in real life.
Why does my trend line look like it does not fit my data?
You are probably using the wrong trend line type. Linear works for steady changes. Exponential works for rapid growth. Polynomial works for curves and waves. Try different types and compare their R-squared values. The highest R-squared indicates the best fit.
Can I move or resize a trend line?
No. The trend line is calculated by Excel based on your data points, so you cannot drag it or resize it manually. If you want to change where it sits, you need to change the trend line type or the data itself.