To remove a trendline from an Excel chart legend without removing the line, click the legend, click the trendline’s legend entry a second time to select just that entry, and press Delete. This hides the legend entry while leaving the trendline visible on the chart.
Quick method: delete only the legend entry
In Excel for Microsoft 365 on Windows, a chart legend is made up of separate entries for the chart’s data series and, when applicable, its trendlines. You can select an individual entry and delete it without deleting the object it represents. The important part is to select the entry inside the legend—not the trendline drawn across the chart.
- Click the chart to activate it.
- Click the legend once. This selects the legend as a whole.
- Click the trendline’s label or key inside the legend again. A selection border or handles should appear around that single entry.
- Press Delete on your keyboard.
The trendline should remain on the chart, but its label and legend key should disappear. If the entire legend vanishes, you selected the whole legend rather than its individual entry. Undo with Ctrl+Z, then try selecting the entry again. If the trendline itself disappears, you selected the plotted line instead of the legend item; undo and click the legend entry carefully.
How Excel separates a trendline from its legend entry
A trendline is a chart element that represents a fitted or smoothed pattern in a data series. Its legend entry is a separate label-and-key item that helps identify that element. Removing the legend entry changes what the legend displays; it does not turn off the trendline or remove the source data.
This distinction is useful when the line is clear on the chart but the legend is crowded, or when a trendline’s default description—such as a series name followed by “Linear”—is too long. Hiding that one entry can make the legend easier to scan while preserving the visual analysis. The trendline may still affect how viewers interpret the chart, so consider adding a brief note or labeling the line directly if its meaning is not obvious.
Deleting the legend item is not the same as deleting the trendline. Excel does not provide a separate checkbox in the usual legend settings for each trendline. Instead, you remove the unwanted individual entry from the displayed legend. The trendline remains a chart object with its existing type, formatting, and options.
Step-by-step selection in Excel for Windows
Because a chart contains many selectable parts, it helps to check what Excel has selected before pressing Delete. Click once on a blank part of the chart area if you need to start over, then use the following sequence:
- Click the chart once so the chart tools become available.
- Click the legend once. Look for handles around the outer boundary of the legend; that indicates the whole legend is selected.
- Click directly on the trendline’s legend text or its small line sample. Avoid clicking the trendline across the plot area.
- Check that the selection is limited to the one legend entry. Excel should show selection handles around the item rather than around the whole legend.
- Press Delete. The entry should disappear while the rest of the legend and the trendline remain.
If a second click does not select the individual item, click the entry again with a short pause between clicks, taking care not to double-click so quickly that Excel opens text editing. Clicking the legend text is often easier than targeting its small line sample. You can also enlarge the chart temporarily or move the legend to a less crowded position to make the entry easier to select.
Confirm the trendline is still on the chart
After removing the key, inspect the plotted line. It should still cross or follow the data as before. If you are unsure, click the line itself. When the trendline is selected, Excel displays handles or a selection outline on the plotted line; the Format Trendline pane or related formatting controls can also help confirm you selected the chart object, not a legend entry.
Do not press Delete after selecting the plotted trendline unless you intend to remove it. If that happens, immediately press Ctrl+Z to restore it. You can also use the Undo button on the Quick Access Toolbar. The chart’s source worksheet values are not deleted by removing a trendline, but deleting a plotted data series is a different operation and can affect the chart’s display.
A useful final check is to click outside the chart and look at it at normal viewing size. Confirm that the trendline is visible, the unwanted legend item is gone, and the remaining entries still clearly identify the data series. If you are preparing a report, save the workbook and reopen it or export a copy to make sure the chart looks as intended in its final setting.
When hiding one entry is better than removing the legend
Removing only the trendline entry is usually the best choice when the legend still helps identify several data series. Removing the entire legend would also remove useful labels for those series. In a simple chart with one data series and one trendline, however, a legend may not be necessary at all; a chart title or direct label could explain the information more cleanly.
- Keep the legend and hide one trendline entry: useful when the remaining entries identify multiple series.
- Remove the whole legend: useful when labels are already clear from direct labels, axis context, or nearby text.
- Rename the trendline: useful when readers need to identify it but the default legend wording is confusing or overly long.
- Label the line directly: useful when the trendline needs explanation in a presentation or printed chart.
To rename a trendline, select the trendline on the chart and open its formatting options. In the Format Trendline pane, look for Trendline Name and choose a custom name if that control is available for the selected chart. A shorter name such as “Linear trend” may be easier to read than a long automatically generated label. Renaming is not the same as hiding the entry: the renamed item will still appear in the legend until you remove it.
Charts with several series or trendlines
In a chart with several data series, each trendline is associated with a particular series. Excel may include an entry for each trendline in addition to the entries for the underlying series. Before deleting a legend item, check its text and line style so you remove the key for the intended trendline rather than a data-series entry that happens to look similar.
For example, imagine a scatter chart with “Store A” and “Store B” data, each with a linear trendline. The legend may show both series and both trendlines. Removing the “Store A Linear” legend entry does not remove the Store A trendline or the Store A data points. It only leaves that particular line without a legend key. The other series and trendline entries remain available for identification.
If several legend entries are crowded together, consider making the chart larger or repositioning the legend before editing. You can also remove entries one at a time, checking the chart after each deletion. Avoid selecting several entries at once unless you specifically want to hide them all. If you later change the chart layout, type, or trendline configuration, review the legend again; rebuilding or changing chart elements may alter its presentation.
Common problems and how to fix them
- The whole legend disappears. You probably selected the legend as a single object. Press Ctrl+Z, select the legend again, and then click directly on the unwanted entry for the second selection.
- The trendline disappears. You selected the line in the plot area. Undo, then click the corresponding label or key inside the legend.
- The wrong item is removed. Undo immediately and identify the entry by its text and line style before deleting it again.
- The entry is difficult to click. Enlarge the chart, move the legend, or zoom in. A trendline key can be a small line segment, so clicking its text may be easier.
- The legend item returns after a chart change. Some chart edits can alter the legend’s displayed elements. Repeat the selection-and-delete method after the chart is in its final configuration.
For a precise selection, do not rely only on the mouse pointer’s location. Check the selection handles before using Delete. That small pause prevents the most common mistake: deleting the trendline when the goal is merely to remove its description from the legend.
Excel for Mac and Excel for the web
In current desktop versions of Excel for Mac, the same basic chart-selection idea applies: select the legend, select the individual trendline entry, and press Delete. On many Mac keyboards, the key labeled Delete acts like Backspace; use it to remove the selected legend item. If your keyboard has a forward Delete key, it may be labeled Fn+Delete or have a separate key, depending on the model. The visible ribbon layout can differ from Windows, but the selection itself is the key step.
Excel for the web has a more limited and changing set of chart-editing controls than the desktop application. If clicking the legend does not let you select an individual trendline entry, open the workbook in the desktop Excel app and use the steps above. The chart should remain in the workbook; avoid changing or deleting chart elements in the browser unless you can confirm the selected object is only the legend entry.
Frequently Asked Questions
Can I remove a trendline from the legend without deleting the trendline?
Yes. Select the individual trendline entry inside the legend and press Delete. The plotted trendline remains visible; only its legend entry is removed.
Why does pressing Delete remove my trendline?
You likely selected the line in the chart’s plot area, not its legend entry. Undo, click the legend, then click the specific trendline label or key and confirm that only that item is selected before pressing Delete.
Can I hide only one trendline entry when a chart has multiple trendlines?
Yes. Select and delete the individual legend entry for the trendline you want to hide. Repeat separately for other entries only if needed, checking that each selection is the intended one.
How do I get a deleted legend entry back?
If you just removed it, press Ctrl+Z on Windows or use Undo. If you have continued editing, the simplest reliable recovery may be to restore an earlier saved version or recreate the trendline; changing the trendline can affect its settings, so check its type and formatting afterward.
Can I rename the trendline instead of removing it?
Yes. Select the trendline and use the Trendline Name controls in the Format Trendline pane when available. Renaming keeps an entry in the legend; deleting the individual entry hides it.
Related
- Excel Protect Sheet Except for Selected Users: How It Works
- Excel Protect Sheet Except Slicer: Setup and Fixes
- Excel Protect Sheet: Can You Edit Objects?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Can You Make a Graph in Google Sheets?Yes—you can make a graph in Google Sheets by selecting your data and choosing Insert > Chart. Sheets…
- Excel Sparklines: Meaning, Types, and How to Use ThemExcel sparklines are miniature charts placed inside individual worksheet cells to show a small set of data as…
- Excel Pivot Chart Colors Keep Changing? Fix the CauseExcel PivotChart colors usually change because filtering, refreshing, or rearranging fields changes which series are displayed or their…
- Pareto Chart Not Working in Excel? Fix Data and Chart IssuesIf a Pareto chart is not working in Excel, first check whether the chart is getting the kind…
- Excel Pivot Table: Filter Dates by YearTo filter an Excel PivotTable by year, group its date field: right-click any date in the PivotTable, choose…
- Add a Trendline to an Excel Bar Chart? Here’s How It WorksYes—Excel for Microsoft 365 on Windows can add a trendline to a supported 2-D bar chart. Select the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.