Change a Trendline Name in Excel’s Legend

Charts & pivot tables · Updated November 18, 2026

To change a trendline’s name in an Excel legend, select the trendline, open Format Trendline, choose Custom under Trendline Name, and type the label you want. The legend updates to show that custom name; it does not change the trendline’s calculation or rename the underlying data series.

Change the trendline name step by step

These instructions apply to Excel for Microsoft 365 on Windows. Start with a chart that already has a trendline and a visible legend. If the chart has several lines, click the line you want to rename; selecting the wrong line can open formatting options for a data series instead of the trendline.

  1. Click the chart, then click the trendline. If selecting it is difficult, use the chart’s Format tab and the Current Selection list to choose the trendline by name.
  2. Right-click the selected trendline and choose Format Trendline. You can also double-click the trendline to open its formatting pane.
  3. In the pane, select Trendline Options if that section is not already open. Find the Trendline Name controls.
  4. Select Custom, then enter a concise label in the text box. For example, replace “Linear (Series 1)” with “Linear fit: 2024 sales.”
  5. Close the pane if you like. The legend should now use the custom label for that trendline.

If the legend is missing, select the chart and add one before checking the result. In Windows, use Chart Design > Add Chart Element > Legend, then choose a position. The chart’s plus button can also be used to turn on Legend. A trendline can be named even when the legend is hidden, but there is no visible legend entry to confirm the change.

What the trendline name controls

Excel treats the plotted data series and its trendline as separate chart elements. A series represents the original values, such as monthly revenue. A trendline is a fitted line or curve based on those values. The trendline name controls the label associated with that fitted line in the legend; it does not rename the source data, alter the plotted points, or change the trendline type.

For instance, a chart might contain a series called “Website visits” and a linear trendline. Giving the trendline the custom name “Linear trend, Jan–Dec” makes the legend more informative while leaving “Website visits” as the name of the actual data series. The trendline’s slope, intercept, forecast settings, and other options remain as they were.

This distinction matters when a chart has several series and trendlines. A legend entry such as “Exponential (Series 2)” can be hard to interpret if the audience does not know what Series 2 means. A custom name can identify both the model and the data context, for example “Exponential fit: online orders.” Make sure the label describes the line you actually selected.

Choosing a useful custom label

A legend label should help readers identify the line without making them decode Excel’s default wording. Include the trendline type when it matters, and add a series name or time period if there are multiple lines. Keep the wording short enough to fit in the chart area.

  • One series and one trendline: “Linear trend” may be enough.
  • Several series: “Linear fit — North region” distinguishes the fitted line from other regions.
  • Comparing models: “Polynomial fit, order 2” communicates the model choice more clearly than a generic “Polynomial” label.
  • Presenting a time period: “Trend, 2022–2025” helps when the chart or report covers a specific period.

Use wording that is accurate, not just persuasive. A trendline describes a pattern in the displayed data; it does not by itself establish a cause or guarantee that the pattern will continue. If the chart includes a forecast, explain that context in the chart title, note, or surrounding text rather than implying that the custom legend name proves a prediction.

Trendline names versus series names

A frequent source of confusion is changing the data series name when the goal is to change the trendline’s legend entry. If you rename the series, Excel may update the label for the data itself, while the trendline still has its own name. Conversely, the custom trendline name does not change the series label.

To change a series name, select the chart and use Chart Design > Select Data. Under Legend Entries (Series), select the series and choose Edit; then change its series name or point it to a cell containing the desired name. The exact dialog layout can vary slightly with the chart and Excel build. This is a different operation from choosing Custom in the Format Trendline pane.

When the legend contains both “Website visits” and “Linear (Website visits),” those entries refer to different elements: the original values and their fitted line. If you want to rename only the trendline, leave the series name alone and edit the trendline’s custom name. If you want both labels to use a new project or category name, update each element separately.

Why the custom name may not appear

If the legend still shows the default wording, check the selection and the chart itself before changing other settings. Excel can make a trendline hard to select when it is close to a data series, particularly on a small chart or when multiple lines overlap.

  • The data series is selected instead: Open the chart’s Format tab and use Current Selection to select the intended trendline. Then reopen Format Trendline.
  • Automatic naming is still selected: In Trendline Options, choose Custom and enter the label. Typing into another field, such as the equation settings, will not set the legend name.
  • The legend is hidden: Add or enable the legend using Chart Design > Add Chart Element > Legend. Also check that it is not outside the visible chart area.
  • The text is difficult to read: Widen the chart, move the legend, or shorten the custom label. A long label can wrap or make the legend consume too much space.
  • The chart is not a suitable chart type: Trendline availability depends on chart type and data arrangement. If Excel does not offer a trendline for the selected chart, changing its name is not possible until you use a supported chart configuration.

After making the change, click elsewhere in the chart and check the legend entry again. If you have several trendlines, select each one deliberately; changing one custom name does not automatically rename the others.

Trendline name and equation display are separate

Excel can display a trendline’s equation and, for some trendline types, an R-squared value on the chart. These are separate chart labels, not the trendline’s legend name. In the Format Trendline pane, the options to display the equation or R-squared value are distinct from the Trendline Name choice.

For example, a chart can have a legend entry named “Linear fit: monthly demand” while the equation appears on the plot as “y = 2.4x + 18.” Changing the custom name does not rewrite that equation, and editing the equation’s displayed text is not the standard way to rename the legend item. If you want a clean chart, you can show the custom legend name and turn off the equation label, or keep both when readers need the model information.

Excel for Mac and Excel for the web

In Excel for Mac, select the trendline and open its formatting pane, then look under the trendline options for the custom name control. The ribbon and pane arrangement can differ from Windows, but the key operation is still to set the trendline name to Custom and enter the label. If a context-menu command or pane is not immediately visible, use the chart’s formatting controls to select the trendline rather than the data series.

Excel for the web may display charts differently and may not expose every chart-formatting control available in the desktop app. If you cannot find the custom trendline name setting in the browser, open the workbook in the Excel desktop app and make the change there. The workbook can then be saved and viewed online, though the precise editing controls depend on the web app’s current feature support.

Frequently Asked Questions

Can I change a trendline name without changing the data series name?
Yes. Select the trendline, open Format Trendline, choose Custom under Trendline Name, and enter a label. The data series name is a separate chart setting.

Why does my trendline legend say “Linear (Series 1)”?
Excel is using an automatically generated name based on the trendline type and its associated series. Choose a custom trendline name to replace that default legend wording with a clearer label.

Can I rename a trendline by editing a worksheet cell?
Not through the normal trendline name control. A trendline’s custom name is set in the Format Trendline pane. Worksheet cells can supply data series names, but that is a separate setting and does not directly replace a trendline’s custom name.

Does renaming a trendline change its equation or forecast?
No. It changes the displayed name, not the trendline calculation or its options. If you need to change the model, such as switching from linear to exponential, use the trendline type settings separately.

Can I remove only the trendline from the legend?
The custom-name setting changes the label; it does not control whether the trendline appears in the legend. To keep the fitted line but simplify the legend, adjust the legend entry or chart layout carefully, and verify that you have not deleted the trendline itself.

Final check before sharing the chart

Read the legend as someone unfamiliar with the workbook would. Confirm that the custom label identifies the correct series and trendline, that the legend is visible, and that the wording is not so long it obscures the data. If the chart is used in a report, keep the legend name consistent with the terms used in the title and explanatory notes. A clear custom name makes the chart easier to interpret, while the underlying data and trendline calculations remain unchanged.

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.