No—Excel supports trendlines, but the option is unavailable for some chart types or when the chart itself, rather than a data series, is selected. In Excel for Microsoft 365 on Windows, select a supported chart and its data series, then choose Chart Design > Add Chart Element > Trendline; choose a type or select More Trendline Options.
Why the Trendline Option May Be Missing
The most common reason is the chart type. Excel does not offer trendlines for every chart. They are generally available for supported two-dimensional charts such as line, column, bar, area, stock, scatter, and bubble charts. Trendlines are not supported for chart types including pie, doughnut, radar, surface, 3-D, or stacked charts. If the chart is stacked or otherwise unsupported, changing it to a compatible chart type is usually the quickest fix.
Selection matters, too. Excel needs a data series to attach the trendline to. Clicking the chart background or its title selects the chart, but not necessarily the plotted values. Click one of the series’ bars, points, or line segments so that the series is selected, then check the Chart Design tab or right-click the series. With a supported chart and series selected, the Add Trendline command should be available.
Also check whether you are using Excel in a browser, a different spreadsheet application, or an older Excel version. Ribbon labels and available chart tools can differ. The instructions below use Microsoft 365 for Windows; if the command is difficult to find in Excel for the web, open the workbook in the desktop app and look under Chart Design.
Add a Trendline in Excel for Windows
First, make sure the chart plots the data you intend to analyze. A trendline is attached to one series, not automatically to every series in a chart. For a chart with monthly sales for three products, for example, you can add a trendline to the sales series for one product and leave the other two unchanged.
- Click the chart, then click the particular data series. For a line chart, click the line; for a column chart, click one of that series’ columns.
- On the ribbon, choose Chart Design > Add Chart Element > Trendline.
- Choose a listed trendline type, such as Linear. To see additional settings, choose More Trendline Options.
- In the Format Trendline pane, select the trendline type and adjust any relevant options, such as forecasting forward or backward.
- If useful, select Display Equation on chart or Display R-squared value on chart to show those statistics on the chart.
You can often use a shortcut from the chart itself: right-click the selected data series and choose Add Trendline. If you right-click an axis, plot area, or chart background instead, the menu may not contain that command. On Excel for Mac, select the series and use the Chart Design tab’s chart-element controls or the series’ context menu; names and ribbon arrangement can vary slightly by release. No keyboard shortcut is required for the standard process.
Check the Chart and the Source Data
If the command remains unavailable, start by identifying the actual chart type. A chart can look like a regular column or line chart while being configured as stacked, 3-D, or another unsupported variation. Select the chart and use Chart Design > Change Chart Type to inspect it. If appropriate, switch to a compatible two-dimensional, non-stacked type and try adding the trendline again. Changing chart type can affect how the data is displayed, so confirm the result still communicates the comparison you need.
Next, inspect the source data and the plotted series. Trendlines are calculated from the points Excel recognizes as numeric values. Numbers stored as text, blank cells, error values, or an incorrectly selected range can leave Excel with fewer usable points than expected or make the chart misleading. Verify that the series includes the intended observations and that the values are numeric. If the chart uses multiple series, select the one you want before adding the line.
- For an XY (scatter) chart, confirm that the intended horizontal values are plotted as X values and the measurements as Y values.
- For a line chart, check the category labels and the order of the observations. A line chart commonly treats categories as evenly spaced positions.
- For dates with irregular gaps, consider whether an XY scatter chart better represents the spacing between observations.
- Remove or correct unintended blank rows, text entries, and errors in the chart’s data range.
These checks can explain why a trendline appears in the wrong place even after Excel lets you add one. A calculation cannot compensate for an incorrect chart range, a mistaken series, or an axis that does not represent the data the way you assume.
Choose a Trendline That Fits the Pattern
Excel offers several trendline types because different data patterns call for different models. A trendline is not simply a decorative line: its type determines how Excel estimates the relationship. Begin with a scatter plot when you have paired numeric X and Y measurements, such as hours studied and test score, or time and temperature. For observations over time, a line chart may be suitable when the intervals are regular.
- Linear: A straight-line model for a pattern that rises or falls at a roughly steady rate. It is often a sensible first check for a general direction.
- Exponential: A curved model for a pattern that changes at a rate proportional to its current level, such as some forms of growth or decay. The data must meet Excel’s requirements for this model, including positive Y values.
- Logarithmic: A curve that can rise or fall quickly and then level out. It requires suitable positive X values.
- Polynomial: A curved model that can bend to follow one or more changes in direction. You can choose its order; a higher order can fit more bends but may also overfit a small dataset.
- Power: A model for a relationship in which one variable changes as a power of another. It requires suitable positive X and Y values.
- Moving Average: A smoothed line that averages a chosen number of neighboring points. Increasing the period makes the line smoother but can hide short-term changes.
Do not select a model only because its line looks attractive. For example, a high-order polynomial can trace a handful of points closely yet behave implausibly beyond them. Choose a model that makes sense for the subject and the data, and treat the trendline as a summary rather than proof that the pattern will continue.
What the Equation, R-squared, and Forecast Mean
The option to display an equation prints the fitted trendline equation on the chart. It can help explain the relationship or support a calculation, but the displayed coefficients may be rounded for readability. If you need precise values, do not assume the few digits printed on the chart are exact. The equation also depends on how Excel interprets the chart’s horizontal axis. On a scatter chart, X values are numeric; on a category-based line chart, the positions may represent category order rather than the actual elapsed time between labels.
R-squared is a measure of how closely the fitted model accounts for variation in the plotted data, on a scale that is commonly shown from zero to one. A value closer to one indicates a closer fit to those observations under that model. It does not establish that the model is appropriate, prove cause and effect, or guarantee accurate future predictions. A model can fit historical points well and still fail when conditions change.
In More Trendline Options, the Forecast controls extend a trendline forward or backward by a number of periods. The meaning of a period follows the chart’s X-axis interpretation; on a category chart, it may mean categories rather than a fixed number of days. Forecasting merely extends the selected mathematical pattern. It does not account for seasonality, business changes, outside events, or uncertainty unless those are separately modeled.
Trendline Versus a Moving Average or Forecast
Readers often use “trendline” to mean any line that summarizes data, but Excel distinguishes a fitted trendline from other chart features. A linear trendline estimates an overall straight-line relationship. A moving-average trendline smooths nearby observations to make short-term fluctuations less prominent. It can clarify direction in noisy data, but it is not the same as a fitted linear model and may not be available for forecasting in the same way as other trendline types.
A forecast is a prediction about future values. Adding a forward forecast to a trendline is one simple extrapolation, not a complete forecasting analysis. If your data have repeated seasonal patterns, irregular time intervals, or important external drivers, a basic trendline may be too simple. Keep the raw observations visible, document the assumptions, and consider a method designed for the data and decision at hand.
Common Misconceptions and Practical Limits
A trendline does not connect every point. A line series connects observations in sequence; a trendline estimates an overall pattern, so individual points may sit above or below it. Similarly, a trendline does not automatically correct bad data. A single unusual value can pull a fitted line, and a chart with very few observations can make a complex model appear more convincing than it is.
It is also easy to confuse correlation with causation. If two plotted measurements move together, the trendline describes their observed relationship; it does not show that one measurement caused the other to change. When presenting a chart, label the series and axes, identify the trendline type, and explain any exclusions or transformations. These details help readers understand what the visual does—and does not—say.
Finally, adding a trendline to a chart does not change the source values. It adds a calculated visual element to the chart. If you edit the plotted data, Excel may recalculate the trendline; if you change the chart type or series, check that the line still represents the intended data.
Frequently Asked Questions
Why is Add Trendline greyed out in Excel?
Usually the selected chart type does not support trendlines, or you have selected the chart area rather than a data series. Try a supported two-dimensional, non-stacked chart, click the series itself, and check Chart Design > Add Chart Element > Trendline.
Can I add a trendline to a stacked column chart?
Excel does not support trendlines on stacked charts. If a trendline is appropriate, change the chart to a compatible non-stacked type, such as a regular column chart or an XY scatter chart, then select the series and add the trendline.
Can I put a trendline on a chart with several data series?
Yes, where the chart type supports trendlines. Add a line to one series at a time by selecting that series first. You can add separate trendlines to other eligible series, but confirm that comparing their fitted patterns is meaningful.
Why does Excel say it cannot create this trendline?
Some trendline models require positive values, and a model may not be suitable for the data supplied. Check for zero or negative values where the selected type does not allow them, verify the plotted X and Y ranges, and try a model that matches the data’s pattern.
Does an Excel trendline predict future values automatically?
No. A trendline summarizes the selected data. You can set a forward forecast in its options for supported types, but that extends the fitted pattern and should not be treated as a guaranteed prediction.
Can I add a trendline in Excel for the web?
Chart controls in Excel for the web can differ from the Windows desktop ribbon and may change over time. If you cannot find the trendline command in the browser, open the workbook in Excel for Microsoft 365 on Windows and use the Chart Design controls described above.
Related
- Excel Solver Parameters: How to Set Them Correctly
- Excel Slicers for Multiple Tables: What Works
- Excel Slicers: Advanced Features and Smart Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Box and Whisker Plot Excel X-Axis Labels ExplainedIn Excel for Microsoft 365 on Windows, box-and-whisker plot x-axis labels usually come from the headers above each…
- Excel Pivot Table Add to Data Model: A Practical GuideTo add data to the Excel Data Model, select a cell in your source range, choose Insert >…
- Butterfly Chart in Excel: How to Build and Format OneTo make a butterfly chart in Excel, put the values for one group in a column as negative…
- Excel Pivot Table: How to Hide Blank Rows and ValuesTo hide a blank category in an Excel PivotTable, open the filter arrow for its Row Labels or…
- Excel for Mac Spiderweb Graph: Create and Format ItYes. In Excel for Mac, a spiderweb graph is called a Radar chart: arrange your categories and values…
- Excel Stacked Bar Chart: Show PercentagesYes. In Excel for Microsoft 365 on Windows, choose a 100% Stacked Bar chart to show each category…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.