Excel Trendline Greyed Out? Causes and Fixes

Charts & pivot tables · Updated November 21, 2026

If Excel’s trendline option is greyed out, first select a plotted data series—not just the chart background—and check that the chart type supports trendlines. In Excel for Microsoft 365 on Windows, click the chart, click the series, then choose Chart Design > Add Chart Element > Trendline; if that command is still unavailable, the chart type or worksheet protection is a likely cause.

Why Excel disables the trendline command

A trendline is calculated from a chart’s data series, so Excel needs a suitable series selected before it can offer the feature. Clicking the blank chart area, a title, an axis, or the legend may select a chart element that cannot have a trendline. The chart can look selected while the series itself is not.

Chart type matters too. Excel supports trendlines on many common two-dimensional charts, but not on every chart. A greyed-out command can therefore be a limitation of the chart rather than a problem with the workbook. A worksheet or chart object that is locked from editing can also prevent changes.

It helps to separate two situations: the Trendline command is disabled, or the command works but a particular trendline type is unavailable or unsuitable. The first usually concerns selection, chart type, or editing permissions. The second usually concerns the mathematical requirements of the chosen model or the data.

Try selecting the data series first

Start with the selection, because it is the quickest thing to check and often fixes the issue without changing the chart. On Windows, use these steps:

  1. Click once inside the chart so the chart-specific ribbon tabs appear.
  2. Click a plotted line, bar, column, or set of points to select its data series. Excel should show selection markers on the series.
  3. Open Chart Design > Add Chart Element > Trendline and choose a type, or right-click the selected series and choose Add Trendline.

If your chart has multiple series, select the one you want to model. A trendline applies to a series, not automatically to every series in the chart. For example, a chart showing monthly sales for three product lines needs a separate trendline added to each product series if you want to show all three.

Be careful not to click a point twice in quick succession: Excel can select an individual data point rather than the whole series. If the menu still does not appear, click an empty part of the chart once and then click the series once. On Mac, the same basic selection idea applies; use the Chart Design tab and the series’ context menu, with a Control-click or two-finger click where needed to open the context menu. Ribbon labels and layout can vary slightly by Excel version.

Check whether the chart type supports trendlines

Trendlines are available for many two-dimensional chart types, including line, column, bar, area, stock, XY (scatter), and bubble charts. Excel does not support adding them to chart types such as pie, doughnut, radar, surface, 3-D, or stacked charts. That includes stacked and 100% stacked column, bar, and area charts.

If the chart is one of the unsupported types, make a compatible chart rather than trying to force the feature. Select the chart and use Chart Design > Change Chart Type. Choose an appropriate two-dimensional type, such as a line chart for values across categories or an XY (scatter) chart for numeric x-values and y-values. If you need the stacked display for comparing parts of a total, keep it and create a separate compatible chart for the trendline analysis.

Changing a chart type can change how Excel interprets the horizontal axis. A line chart commonly treats its horizontal labels as categories in sequence, even when those labels look like dates or numbers. An XY (scatter) chart uses numeric x-values. If the spacing between dates or measurements is irregular, a scatter chart is often the more informative choice because the x-axis reflects those actual intervals.

Make sure the worksheet or chart is editable

A protected worksheet may prevent editing chart objects. If you can select the chart but cannot change its elements, check Review > Unprotect Sheet. Excel may ask for a password; do not try to bypass protection. Ask the workbook owner for access or an editable copy if you do not have the password.

Also check whether the workbook is open in a read-only state, such as a protected or restricted view, or whether your permissions allow editing. If Excel shows an editing notice, follow the available prompt to enable editing only when you trust the file and its source. In a shared workbook, another user’s permissions or a read-only copy may limit what you can change.

Protection is different from the chart simply being selected incorrectly. If the worksheet is protected, changing the selection may not help. Conversely, if the sheet is editable and other chart elements can be changed, first recheck that the data series—not the chart area—is selected.

Check the data behind the chart

A trendline needs plotted data points to fit a pattern. Confirm that the series contains at least two usable observations and that the chart is actually plotting the cells you expect. A blank chart, a series with only one point, or a series made up entirely of text or empty cells cannot provide a meaningful fitted line.

Click the chart and inspect Chart Design > Select Data to review the chart’s data range and series. Look for an accidentally shortened range, a header included as a value, or cells stored as text rather than numbers. For a scatter chart, confirm that both the x-values and y-values refer to the intended numeric ranges. Correcting the source range or converting numeric-looking text into numbers can resolve a data problem, although it will not make an unsupported chart type eligible.

Dates and category labels deserve special attention. If you want to model a relationship such as advertising spend versus sales, use an XY (scatter) chart with spend as the x-values and sales as the y-values. A line chart may instead treat the observations as equally spaced categories, which can give a different interpretation when the x-values are unevenly spaced.

Choose a trendline that fits the question

Once the command is enabled, Excel offers different models for different patterns. A straight line is not automatically the best choice just because it is the default or the easiest to read. Consider the data and the question before selecting a type:

  • Linear: estimates a straight-line relationship. It is a reasonable starting point when the change appears roughly constant across the x-values.
  • Exponential: models a pattern that changes by a proportional rate. It is not appropriate when the data required by the model include zero or negative values.
  • Logarithmic: can model rapid early change followed by slower change; it requires suitable positive x-values.
  • Power: models a curved relationship between positive x- and y-values.
  • Polynomial: can follow a curve with one or more bends. A high order may fit the observed points closely but can make the pattern harder to interpret.
  • Moving average: smooths short-term variation over a chosen number of points. It is useful for viewing a fluctuating sequence, but it is not the same as a fitted equation for forecasting.

Some model types have mathematical limits, so a choice may be unsuitable even when Excel lets you open the formatting pane. For example, a logarithmic model cannot use nonpositive x-values, while exponential and power models have their own restrictions. If a type is unavailable or produces an error, inspect the actual values and use a model that matches both the data and the intended interpretation.

What to do if the menu is still greyed out

Work through these checks in order, changing one thing at a time so you can identify the cause:

  • Select a plotted series, not the chart border, a label, or an individual point.
  • Confirm the chart is a supported two-dimensional type and not stacked, 3-D, pie, doughnut, radar, or surface.
  • Verify that the series has at least two numeric observations and that its chart data range is correct.
  • Check whether the worksheet is protected or the file is read-only.
  • If you are using Excel for the web and cannot find the relevant control, open the workbook in the desktop Excel app; the available controls and layout can differ.

If the chart is a PivotChart or a specialized chart, try creating a regular chart from the summarized values in a worksheet range. This is a diagnostic workaround, not a guarantee that every PivotChart limitation has the same cause. It can show whether the issue is tied to the chart object or to the data and chart type. Keep the original chart if it is needed for interactive filtering.

When a command appears enabled but the trendline does not look right, check the selected series and the axes rather than repeatedly changing chart types. A trendline only describes the values in that series. It does not prove causation, explain unusual observations, or guarantee that the pattern will continue beyond the displayed data.

Trendline versus a calculated forecast

A chart trendline is a visual and analytical feature attached to a plotted series. In desktop Excel, selecting or formatting it can let you display its equation and an R-squared value on the chart. The displayed equation is rounded for presentation, so using the rounded coefficients for precise calculations can produce slightly different results.

A trendline is not the same as a forecast function or a guarantee about future results. For a report, it can help communicate a broad pattern, but a forecast needs a suitable method, relevant assumptions, and enough context about the data. Likewise, an R-squared value describes how well a fitted model accounts for variation in the observed data under that model; it does not establish that the model is appropriate or that one variable causes another.

Frequently Asked Questions

Why is Add Trendline greyed out in Excel?
Most often, the chart area or another chart element is selected instead of a data series, or the chart type does not support trendlines. Select the series and check that the chart is a supported two-dimensional type.

Can I add a trendline to a stacked chart?
No. Excel does not support trendlines on stacked chart types, including 100% stacked charts. Use a compatible chart such as a line or scatter chart if a trendline is essential, or keep the stacked chart and show the trend separately.

Can a trendline be added to a line chart?
Yes, a standard two-dimensional line chart supports trendlines. Select the plotted line first. If the horizontal values represent uneven time intervals or numeric measurements, consider an XY (scatter) chart so Excel uses numeric x-values instead of treating the labels as equally spaced categories.

Why can’t I add a trendline to a pie chart?
A pie chart shows parts of a whole rather than a sequence of paired x- and y-values, so Excel does not offer a trendline for it. Choose a compatible chart type that represents the relationship or sequence you want to analyze.

Why is only one trendline available, or why is a trendline type unavailable?
Trendlines are added to individual series, so select another series to add another line. If a particular model is unavailable or unsuitable, check its data requirements; different trendline types require different kinds of values.

Bottom line

When Excel’s trendline option is greyed out, select the plotted data series first, then confirm the chart type supports trendlines and the worksheet is editable. If those checks pass, inspect the series range and values. Once the command becomes available, choose a trendline that fits the data and treat it as a model of the displayed observations—not as proof that the pattern will continue.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.