To remove a trendline in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element > Trendline > None. Or click the trendline itself and press Delete. These actions remove the line from the chart without deleting the underlying data or the data series.
Remove a trendline from the ribbon
The ribbon method is useful when you want Excel to stop displaying a trendline for a particular series and the line is difficult to click directly. First, click the chart so the chart-specific tabs appear. On the ribbon, choose Chart Design > Add Chart Element > Trendline > None. Excel removes the trendline associated with the selected data series.
Pay attention to which series is selected if your chart contains more than one. A trendline belongs to a data series, so a chart with several series can have separate trendlines. Removing one does not necessarily remove the others. If the chart still shows another fitted line, repeat the process for the relevant series, or select that line directly and delete it.
If the Trendline menu does not show the expected choice, verify that you selected a chart and that the chart type supports trendlines. You can also use direct selection: click the visible trendline and press Delete. The Delete key removes the selected chart element, not the worksheet cells that supplied the chart data.
Delete only the line with the keyboard or mouse
Direct deletion is often the quickest approach. Click the trendline once and check that Excel has selected the line rather than the whole chart or the data series. Then press Delete. Alternatively, right-click the selected trendline and choose Delete if that command appears in the context menu.
Charts can be crowded, and a trendline may overlap the series it summarizes. If a click selects the wrong object, use the chart’s selection controls instead of repeatedly clicking. Select the chart, open its contextual Format tab, and use the Current Selection dropdown to choose the trendline entry. Press Delete after confirming that the selected item is the trendline. The entry may include a trendline type or series name, especially when the chart has multiple series.
On a Windows keyboard, Delete removes the selected element. On a Mac, select the trendline and press the Delete key; depending on the keyboard, this may be labeled Backspace. If the key edits text or appears to do nothing, confirm that the trendline itself—not a cell, chart title, or data label—is selected.
What happens to the data, equation, and chart
A trendline is a chart element that summarizes a pattern in a series. Removing it changes the chart’s presentation; it does not erase the source values, change formulas in the worksheet, or remove the plotted data series. For example, if a scatter chart displays monthly advertising spend and sales with a linear trendline, deleting the line leaves the spend-and-sales points in place.
Any equation or R-squared value displayed as part of that trendline is associated with it. When you delete the trendline, its displayed equation and R-squared label are removed as well. If you need to keep those figures for a report, record them first or calculate and display the relevant statistics separately. Deleting the trendline is not the same as deleting a manually typed text box that happens to look like an equation; a separate text box may remain because it is an independent chart object.
Removing a trendline also does not alter the chart’s underlying data range or recalculate the source values. If the chart is linked to a table, new rows may still appear in the series according to the table and chart settings. The trendline itself will not reappear just because the data changes, unless you add one again or use automation that rebuilds chart formatting.
Remove one trendline when a chart has several
Excel can display trendlines for multiple data series in the same chart. A common example is a scatter chart comparing actual results for several regions, with a separate fitted line for each region. To remove just one, select that specific trendline and delete it, or select the corresponding series and choose Chart Design > Add Chart Element > Trendline > None.
Check the legend and the line’s position before deleting. A trendline can look similar to a plotted series, particularly when both use solid lines or similar colors. The plotted series represents actual data points or values; the trendline is a calculated summary. Selecting the wrong object could remove the series from the chart instead. If in doubt, use the Current Selection dropdown and inspect the selected object’s name before pressing Delete.
There is no need to remove and recreate the entire chart just to get rid of one fitted line. Keeping the chart intact preserves its title, axes, legend, formatting, and data-source connection. If several trendlines need to go, remove them one at a time and check the chart after each deletion. This makes it easier to catch an accidental removal of a data series.
Trendlines versus ordinary lines and forecast lines
Not every line drawn across a chart is a trendline. A line chart’s series connects actual observations. A trendline is a separate chart element calculated from a series. A horizontal target or benchmark may be a separate data series, and a forecast may be represented by added values or a forecast worksheet. Deleting a trendline will not remove those other objects.
For instance, a monthly sales chart might contain a blue line connecting monthly totals, a dashed trendline showing the general direction, and a red target series. Removing the dashed trendline leaves both the sales line and red target line intact. If the line you want to remove is still there afterward, identify whether it is a plotted series, a manually drawn shape, an error bar, or another chart element before changing anything.
Trendlines are available only for supported chart types. If Excel does not offer a trendline for a chart, the chart type may not support one; certain chart families, including pie and 3-D charts, are not suited to trendlines. You can change to a compatible chart type when a trendline is needed, but changing chart type is unnecessary when the only goal is to remove an existing line.
Common problems and practical fixes
- The whole chart disappears: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. You likely selected the chart object and deleted it, rather than selecting its trendline.
- The data series disappears: Undo, then select the trendline more precisely. The series and its trendline can overlap, so use the Current Selection dropdown to target the trendline by name.
- The line seems impossible to select: Click the chart first, then use the Format tab’s Current Selection dropdown. This is more reliable than clicking a line that overlaps data points.
- An equation remains on the chart: It may be a separate text box rather than the trendline’s built-in equation label. Select the text box independently and delete it only if you no longer need it.
- The trendline returns later: Check whether a macro, template, or chart-rebuilding process is recreating it. Ordinary changes to chart data do not normally restore a trendline that was removed.
Undo is useful immediately after an accidental deletion, but it is not a substitute for saving important work. If a chart has complicated formatting, save the workbook before making several changes. You can also copy the chart to another sheet as a visual backup, particularly before removing multiple elements from a presentation-ready chart.
Excel for Mac and Excel for the web
In Excel for Mac, the direct method is similar: select the chart element that is the trendline and press Delete or Backspace. The chart ribbon labels and placement can vary slightly by Mac release, so selecting the trendline itself is often the least ambiguous route. If you use a ribbon command, look for the chart design controls and the Trendline options after selecting the chart.
Excel for the web has a more limited and changing chart-editing interface than the Windows desktop app. If the trendline is selectable in your browser, select it and use the available delete command. If you cannot select or remove it, open the workbook in the desktop Excel app and use the ribbon or direct-selection steps above. Editing in the desktop app is also preferable when the chart has multiple overlapping series or carefully formatted elements.
These instructions concern removing a trendline from a chart, not deleting data or formulas from the worksheet. If the workbook is shared, changes may be visible to collaborators after they sync. Consider making a copy before editing a shared or important workbook, especially if you are unsure which chart object is selected.
When to remove a trendline—and what to use instead
A trendline can be useful when it clarifies a relationship or direction, but it can also distract from the observations or suggest more certainty than the data supports. Remove it when the chart’s purpose is to show the recorded values, when the fitted line is misleading for the pattern, or when the chart is too crowded. A trendline is a model of the displayed data, not a guarantee that future values will follow the same path.
If the goal is to show a target, use a clearly labeled target series or reference line rather than treating a fitted trendline as a target. If you only want to hide the trendline temporarily, Excel does not provide a general visibility switch for every chart element; removing it and adding it again later may be simplest. You can preserve the equation or other analysis separately if that information is important to your audience.
To add a trendline again later, select the chart and choose Chart Design > Add Chart Element > Trendline, then choose an available type such as Linear. Excel may offer different types depending on the chart and data. Choose a type that makes sense for the relationship rather than selecting one solely because it produces a visually appealing curve.
Frequently Asked Questions
How do I remove a trendline in Excel without deleting the chart?
Select the trendline itself and press Delete, or choose Chart Design > Add Chart Element > Trendline > None. Do not press Delete while the chart’s outer border is selected.
Can I remove just one trendline from a chart?
Yes. Select the particular trendline or its associated series, then remove that trendline. Other trendlines and data series can remain in the chart.
Does removing a trendline delete the data?
No. It removes the chart’s fitted line, not the worksheet values or the plotted series. The data remains available for the chart and for other calculations.
Why does the trendline equation disappear too?
The equation and R-squared label displayed for a trendline are tied to that chart element, so they are removed with it. A separately created text box may need to be deleted on its own.
Why can’t I click the trendline?
It may overlap the data series or another chart object. Select the chart, use the Format tab’s Current Selection dropdown to choose the trendline, and then press Delete.
Related
- Excel Import Multiple CSV Files: Methods and Tips
- How to Export a CSV File in Excel Without Losing Data
- Excel Import CSV with Line Breaks Without Splitting Rows
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Chart Hide Buttons: How to Remove Field ButtonsTo hide PivotChart buttons in Excel for Microsoft 365 on Windows, select the chart, then choose PivotChart Analyze…
- Dual Axis Combo Chart in Excel: Create and Format ItIn Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart > Create…
- Bar Chart Formula in Excel: How to Create OneThere is no special Excel formula that creates a bar chart: a chart is an object you insert…
- Excel Pivot Table Rows Side by Side: Layout, Steps, and TipsTo put PivotTable row fields side by side in Excel for Microsoft 365 on Windows, click inside the…
- Excel Chart With Drop-Down List: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a drop-down with Data Validation, use a helper column…
- Excel Graphs for Beginners: How to Choose and Make ThemExcel graphs—called charts in Excel—turn rows of worksheet data into a visual summary. To make one in Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.