Yes—Excel has a trendline option, but it appears only for supported chart types. In Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element > Trendline and select a type; if the option is missing, check the chart type and whether you have selected a data series.
Where to find the trendline command
A trendline is added to a data series, not to a worksheet range by itself. First create a chart from the data, click the chart, and then select the series you want to analyze. The Chart Design tab appears when a chart is selected. Use its Add Chart Element menu to choose a trendline type, or choose More Trendline Options to open the formatting pane and configure it.
There is also a quick route in many desktop versions of Excel: select the chart, click the plus-shaped Chart Elements button beside it, and check Trendline. Use the arrow beside that option to choose a trendline type or open more options. If you have several plotted series, Excel may offer to add the trendline to the series you selected. Repeat the process for another series if you want separate fits.
- Arrange the observations in columns or rows, with a heading for each series.
- Select the data and choose Insert > Recommended Charts or a chart type suited to the data.
- Click the chart, then click the specific series you want to analyze.
- Choose Chart Design > Add Chart Element > Trendline and select a type such as Linear.
- For settings such as a displayed equation or forecast, choose More Trendline Options.
What a trendline shows
A trendline is a mathematical model fitted to the plotted values. It summarizes a pattern, such as a general increase or decrease, rather than joining every point in sequence. A linear trendline, for example, represents a straight-line relationship between the chart’s x-values and y-values. Other types can model some curved patterns.
It is a visual aid, not proof that one variable causes another or that a pattern will continue. A trendline can be misleading if the data cover too short a period, contain unusual outliers, or change direction. Review the points and the context before relying on the line, especially when using it to discuss future values.
For a chart with multiple series, each series can have its own trendline. The line is calculated from the points in that series. If the chart compares groups with very different scales or meanings, a single trendline across all groups is not automatically appropriate; assess each series separately.
Which Excel charts support trendlines?
Excel offers trendlines for several common two-dimensional chart types, including scatter (XY), bubble, line, column, bar, area, and stock charts. The exact choices available can depend on the chart and its series. A scatter chart is often the clearest choice when both variables are numeric and the horizontal values represent real measurements, such as temperature or elapsed time.
Trendlines are not available for every chart. In particular, Excel does not support them on pie, doughnut, radar, surface, 3-D, or stacked chart types. PivotCharts can also lack trendline support. If Excel does not show the command, changing the chart to a supported, non-stacked 2-D type is a useful first check. For some data, changing chart type is also the better analytical choice, not just a workaround.
There is an important distinction between a line chart and a scatter chart. A line chart usually treats horizontal positions as categories, such as months or product names; points are spaced by category order. A scatter chart uses numeric x-values and positions points according to their numerical distances. If intervals between dates or measurements are uneven, a scatter chart can represent that spacing more faithfully.
Choosing the right trendline type
Excel’s options include Linear, Exponential, Logarithmic, Polynomial, Power, and Moving Average. The best choice depends on the shape of the data and the question being asked. Do not select a curved model merely because it looks closer to a small set of points; a more complicated curve can fit those observations while being less useful for understanding the underlying pattern.
- Linear: Use when the values change at a roughly steady rate. It is a reasonable starting point for a simple upward or downward trend.
- Exponential: Use for a pattern that grows or declines by a roughly consistent percentage, rather than a consistent amount. This model requires positive y-values.
- Logarithmic: Use for a pattern that changes quickly at first and then levels off, when the x-values are positive.
- Polynomial: Use when the data have one or more bends. Excel lets you set the polynomial order; higher orders can create more bends and may overfit.
- Power: Use when the relationship is described by a power curve. This model requires positive x- and y-values.
- Moving Average: Use to smooth short-term fluctuations and make the underlying movement easier to see. The period determines how many points contribute to each average.
For example, monthly sales that rise by about the same number of units each month may be reasonably summarized by a linear fit. If sales instead increase by a similar percentage each month, an exponential fit may be more suitable. These are clues, not automatic rules: inspect the data, consider how the values were collected, and avoid extending a model beyond a range where it makes sense.
Showing the equation, fit, or forecast
Choose More Trendline Options to open the formatting pane. Depending on the type, you can set the trendline’s name, adjust its style, and use forecast settings to extend it forward or backward. A Moving Average is a smoothing method and is not a forecast line in the same way as the fitted mathematical models.
For supported fitted types, the pane can also display the equation on the chart and show the R-squared value. The equation describes the fitted relationship; R-squared is a measure of how closely the model’s values correspond to the observations in the data used for the fit. A higher R-squared does not prove that the model is correct, that the relationship is causal, or that its forecasts will be accurate. It can also make a poor choice of model look convincing when the data are limited.
Excel rounds the equation displayed on the chart. If you need to reuse its coefficients in a calculation, do not assume the visible rounded numbers give the full precision of the fitted model. Also remember that a forecast extension is a mathematical extrapolation. For example, a straight line fitted to a short run of rising monthly values will keep extending at that rate even if real-world conditions later change.
Why the trendline option may be missing
When the Trendline command is absent or unavailable, work through the chart and selection first. The problem is often a limitation of the chart type rather than a missing Excel feature.
- Check the chart type. Pie, radar, 3-D, surface, and stacked charts do not support trendlines. Try a compatible 2-D chart where it suits the data.
- Select a plotted series. Click a data point or the series in the chart, rather than selecting only the chart area or a legend entry. Then check the Chart Design menu again.
- Check whether it is a PivotChart. PivotCharts have restrictions on chart features. If appropriate, create a regular chart from a copied or otherwise usable summary of the PivotTable results.
- Confirm that the series contains usable values. Text values, blanks, or a series with too few meaningful numeric observations may prevent the result you expect. Check the source range and axis assignments.
- Try the desktop app. Excel for the web has a different, more limited chart-editing interface in some cases. If a control is not available there, open the workbook in desktop Excel and check the chart options.
If Excel adds a line but it looks wrong, check that the intended series was selected and that the x-values are assigned correctly. On a scatter chart, use the Select Data controls to inspect each series’ x- and y-value ranges. On a line chart, verify the category labels and their order. A trendline can only summarize the values Excel is actually plotting.
Trendline versus a connected line or moving average
A chart’s ordinary line and its trendline are different things. A line chart connects successive observations in order, which is useful for showing how a series changes from point to point. A trendline summarizes the overall relationship across those observations and may not pass through any particular point. A scatter chart can show markers without connecting them, then add a fitted trendline.
A Moving Average trendline is also different from simply connecting the original values. It smooths local fluctuations by averaging a chosen number of neighboring observations. A larger period generally produces a smoother line but can hide turning points or make changes appear later. It is useful for visualizing a noisy series, but it should not be mistaken for a causal explanation or a prediction guarantee.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, select the chart and look for the Chart Design tab and its Add Chart Element menu. The ribbon layout and placement of controls can vary slightly from Windows, but the trendline settings are broadly similar. If the chart type does not support trendlines, changing the ribbon layout will not make the option appear.
Excel for the web uses a different chart-editing interface, and some chart-formatting options can be more limited or placed differently than in the desktop app. Select the chart and inspect its chart controls for a trendline option. If you need a setting that is not offered in the browser, use Open in Desktop App and configure the chart in Excel for Windows or Mac. The workbook can then be saved and reopened online.
Frequently Asked Questions
Does Excel have a trendline option?
Yes. For a supported chart, select the chart and series, then choose Chart Design > Add Chart Element > Trendline. The command is unavailable on some chart types, including pie, radar, stacked, and 3-D charts.
Why can I not add a trendline to my Excel chart?
The chart may be an unsupported type, such as a stacked or 3-D chart, or it may be a PivotChart. Make sure you selected a data series, and check that its plotted values and source ranges are appropriate. A compatible two-dimensional chart may resolve the issue.
How do I show the trendline equation in Excel?
Select the trendline or add one through Chart Design > Add Chart Element > Trendline > More Trendline Options. In the formatting pane, select the option to display the equation on the chart. The equation is rounded for display, so use care if you copy its coefficients into calculations.
Can an Excel trendline predict future values?
You can extend some fitted trendlines forward using the Forecast settings in More Trendline Options. This extends the selected mathematical model; it does not account automatically for future events or changing conditions. Treat it as an extrapolation, not a guarantee.
Should I use a line chart or a scatter chart for a trendline?
Use a scatter chart when both axes represent numeric values and the spacing between x-values matters. Use a line chart when the horizontal axis is a sequence of categories, such as months in order. The chart choice affects how Excel interprets the horizontal positions and therefore what the fitted trendline represents.
Related
- Compare Numbers in Two Excel Sheets: A Practical Guide
- Recover a Corrupted Excel File From Your PC
- How to Add Rows to an Existing Group in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Half Circle Chart: How to Create OneTo make a half-circle chart in Excel, create a doughnut chart with two visible values and a third…
- Excel Pie Chart: Group Small Categories into OtherTo group data in an Excel pie chart, first summarize the values you want to show, then chart…
- Excel Stacked Bar Chart from a PivotTable: How to Make OneYes. In Excel for Microsoft 365 on Windows, select a cell in your PivotTable, choose PivotTable Analyze >…
- Edit a Pivot Table in Google Sheets: Steps and TipsTo edit a pivot table in Google Sheets, click any cell inside it to open the Pivot table…
- Gantt Chart Excel Template Free Online: What to KnowYes. You can find free Gantt chart Excel templates online through Microsoft Create, Excel’s template gallery, and other…
- Excel Donut Chart Progress: Build a Progress RingTo make an Excel donut chart show progress, give it two values: the amount complete and the amount…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.