If the Trendline option is missing in Excel, select a data series inside the chart, not the chart background, and check that the chart type supports trendlines. In Excel for Microsoft 365 on Windows, right-click a series and choose Add Trendline, or use Chart Design > Add Chart Element > Trendline; if neither route is available, the chart type or selected object is usually the reason.
Why the Trendline option may be missing
Excel adds a trendline to a data series, which is the set of related values plotted as bars, points, or a line. A chart can be selected without a particular series being selected. If you click the chart’s plot area, title, legend, or axes, Excel may show chart-level commands rather than the series-specific Add Trendline command. This is the most common reason the option seems to have disappeared.
The other frequent cause is an unsupported chart type. Trendlines are intended to fit a model to a series of data points, so Excel does not offer them for every chart. A series must also contain enough usable observations for a meaningful fit. A chart with one plotted point, or no numeric values in the selected series, cannot provide a useful trendline.
These causes are separate: changing the chart type will not fix a misselected chart element, and selecting the series will not make an unsupported chart eligible. Work through both checks before rebuilding the chart.
Select the data series, not the chart area
Click the chart once to select it, then click one of the plotted bars, markers, or the line belonging to the series you want to analyze. In a column chart, clicking one column generally selects the whole series; clicking the same column again may select only that individual data point. Right-click the selected series and look for Add Trendline.
If clicking the chart is difficult, use the chart’s selection controls. Select the chart, open the Format tab, and use the Current Selection list to choose a named series, such as Series 1. Then right-click the selected series or open its formatting options. The exact labels in the list depend on the chart’s data and any custom series names.
For a ribbon route in Excel for Microsoft 365 on Windows:
- Select the chart, then select the data series you want to fit.
- Open Chart Design > Add Chart Element > Trendline.
- Choose a model, or choose More Trendline Options to open the formatting pane and set the model and display options.
If you use a Mac, the chart-specific ribbon tab and Add Chart Element command are available in current Excel versions, though the layout can differ by version. Control-clicking a selected series can open its context menu if your mouse or trackpad is configured for secondary clicks. If Excel for the web does not show the same controls, open the workbook in the desktop app and repeat the steps there.
Check whether your chart type supports trendlines
Excel supports trendlines on many common two-dimensional charts, including column, bar, line, area, XY (scatter), bubble, and stock charts. However, a chart being two-dimensional does not automatically make it eligible. Trendlines are not available for chart types such as pie, doughnut, radar, surface, and 3-D charts, and stacked charts are not suitable for adding a trendline.
Stacked charts deserve particular attention. In a stacked chart, each series is drawn on top of the values below it, so its plotted height represents a cumulative total rather than the original series values. A trendline fitted to that visual position would not describe the original observations in the way many readers expect. If the analytical goal is to see how one series changes over time, switch to an unstacked chart or create a separate chart from the original values.
To change the chart, select it and use Chart Design > Change Chart Type. Choose a compatible two-dimensional chart, then select the series again and try Add Trendline. Changing chart type can alter the way categories and series are displayed, so check the labels and legend afterward. Do not choose a different chart merely to make the command appear if that chart would misrepresent the data.
Inspect the data and the plotted series
A trendline can only be fitted to the values represented by the selected series. Check that the chart points to the intended cell range and that Excel has interpreted the rows, columns, and headings correctly. If a chart plots a text column instead of the numeric measurement column, selecting that series will not produce the expected option. Use Chart Design > Select Data to review the chart data range and its series.
For an XY scatter chart, each point has numeric x and y values. This is often the clearest choice when the horizontal values are measurements such as elapsed time, distance, or temperature, especially when the intervals between x-values are uneven. A line chart usually treats its horizontal axis as categories, with points spaced by position rather than by the numeric distance between their labels. That difference can affect what a trendline means even when the chart appears similar.
Look for data that Excel may not be plotting as expected:
- Blank cells, text stored where numbers are expected, or error values can leave gaps or remove observations.
- A filtered table or hidden rows may cause some values not to appear, depending on the chart’s hidden-and-empty-cell settings.
- A chart with several series may have the wrong series selected, or a series may contain only one usable point.
- Date labels that are actually text can behave differently from real Excel dates, particularly when the intended horizontal scale is a timeline.
Correct the source data or chart range first, then reselect the series. Do not replace missing values with zero unless zero is genuinely what those observations mean; doing so can change the apparent direction and fit of the trend.
Choose a trendline that fits the question
Once the option appears, Excel offers several model types. A linear trendline is a straight-line summary and is a reasonable starting point when the change is approximately steady. It does not prove that the relationship is truly linear or that the pattern will continue beyond the observed data.
Other choices include exponential, logarithmic, polynomial, power, and moving average trendlines. They describe different shapes and rely on different assumptions. Exponential, logarithmic, and power fits require suitable positive data; they may be unavailable or fail when the series includes zero or negative values. A polynomial can bend to follow a curved pattern, but a higher order can also chase random fluctuations. Moving average smooths short-term variation rather than estimating the same kind of relationship as a fitted straight line.
To inspect the available settings, select the series, choose Add Trendline, and open More Trendline Options. In the Format Trendline pane, choose the type and, where offered, adjust options such as polynomial order or moving-average period. Excel can also display the equation and the R-squared value on the chart. Treat these as descriptive aids: a high R-squared value by itself does not establish causation, validate a forecast, or show that the chosen model is appropriate.
A practical example: if monthly sales rise by roughly similar amounts, a linear trendline may summarize the observed pattern. If the chart is a line chart with months as categories, the model uses their order as the horizontal progression. If the actual dates are irregular or the spacing between measurements matters, an XY scatter chart with numeric date or time values may be more appropriate. The chart choice should match the question before the trendline type is chosen.
Common fixes when the command still does not appear
If the chart type appears compatible and the correct series is selected, try these checks in order:
- Click directly on a plotted point, bar, or line, then right-click and inspect the menu again.
- Use the Current Selection list to confirm that Excel selected a series rather than the chart, plot area, axis, or legend.
- Use Chart Design > Select Data to confirm the series includes numeric observations and the intended cells.
- Change an unsupported chart to a suitable unstacked, two-dimensional type, then try adding the trendline again.
- If the chart is a PivotChart or uses a special chart arrangement, try a regular chart built from the summarized values in worksheet cells. This can help distinguish a chart-specific restriction from a data problem.
- Save the workbook, close and reopen it if the chart controls appear unresponsive, and verify that you are editing the workbook in desktop Excel rather than a limited preview.
Also check whether the trendline is already present but hard to see. It may use a similar color to the series, be hidden behind another plotted line, or be covered by chart elements. Select the series and inspect its options; if a trendline is present, the formatting pane can help identify and change its appearance. A trendline may also be visible while its equation label is not: showing the equation is a separate option in the Format Trendline pane.
Frequently Asked Questions
Why is Add Trendline greyed out in Excel?
Excel may not have a supported data series selected, the chart type may not support trendlines, or the series may lack usable numeric observations. Select the plotted series and check the chart type and source range.
Can I add a trendline to a column or line chart?
Yes, standard two-dimensional column and line charts can support trendlines. Select the data series rather than the chart background. For a line chart, remember that the horizontal axis commonly represents categories spaced by position.
Why can’t I add a trendline to a stacked chart?
Stacked charts display cumulative series values, which makes a trendline on the plotted shape potentially misleading. Use an unstacked chart of the original values when you need to assess a series’ trend.
Why does my trendline not appear even after I add it?
It may blend into the data series, be obscured by other chart elements, or be difficult to see at the current scale. Select the series, open the trendline formatting options, and use a contrasting line style. The equation label is optional and must be enabled separately.
Can Excel show a trendline equation and forecast?
Yes. In the Format Trendline pane, you can choose to display the equation and R-squared value, and some model types allow a forecast extension forward or backward. These are model-based extensions of the plotted data, not a guarantee of future results.
When a trendline is the wrong tool
A trendline is useful for summarizing a pattern in a chart, but it is not always the right way to analyze a dataset. If the data are categorical, have several distinct groups, contain strong seasonal cycles, or change direction repeatedly, a single trendline can hide the important structure. Consider plotting separate series, charting the data at a finer time scale, or comparing the values directly before interpreting a fitted line.
For a simple visual check, a trendline can make a broad upward or downward tendency easier to see. For decisions that depend on accurate forecasting or statistical inference, examine the underlying observations and model assumptions rather than relying only on a line drawn on a chart. The command being available means Excel can fit a trendline to that series; it does not mean every trendline is meaningful.
Related
- Importing CSV Into Excel: Steps, Settings, and Fixes
- Import CSV Into Excel Without Losing Leading Zeros
- Import CSV Into an Existing Excel Table: Steps & Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Google Sheets, put each task and its start and end dates in…
- Excel Pivot Table Not Grouping Dates? Causes and FixesIf Excel will not group dates in a PivotTable, first check the source date column for blanks, errors,…
- Pie Chart Creator Online in Excel: How to Make OneYes. In Excel for the web, select a table containing category names and values, then use the Insert…
- Excel Graph Secondary Axis: How to Add and Use OneTo add a secondary axis to an Excel graph, select the chart, choose Chart Design > Change Chart…
- How to Change Legend Names in an Excel PivotChartTo change a legend name in an Excel PivotChart, rename the field caption or item that supplies the…
- Excel Pie Chart: Remove Zero-Value LabelsTo remove a zero-value label from an Excel pie chart, click the chart, click the label once to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.