To rename a trendline in Excel for Microsoft 365 on Windows, select the trendline, open its formatting pane, and under Trendline Options choose Custom beside Trendline Name. Type the label you want; if the chart has a legend, the new name appears there. This changes the trendline’s displayed name, not the name of the data series or the equation shown on the chart.
Rename a trendline step by step
Start by clicking the chart that contains the trendline. Then select the trendline itself. If the line is difficult to click because it overlaps the data or another line, click near a visible section of it, or use the chart’s selection list as explained below. Right-click the selected line and choose Format Trendline to open the formatting pane.
- In the Format Trendline pane, select Trendline Options if that section is not already open.
- Find the Trendline Name controls, usually near the top of the options.
- Select Custom instead of Automatic.
- Click the name box, replace its contents with a descriptive label, and press Enter.
For example, a chart of monthly sales might have a data series named Actual Sales and a linear trendline. You could give the trendline the custom name Sales direction. If a legend is displayed, its entry will use that text. The custom name is just a label: it does not change the chart data, the trendline calculation, or the line’s appearance.
You can also open the options from the ribbon. Select the chart, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options. Select the trendline first if Excel does not open the pane for the intended line. Ribbon wording or layout can vary slightly with window size and updates, but Format Trendline leads to the same settings.
What the trendline name changes
A trendline is a calculated line added to a chart series to show a pattern or fitted relationship. Excel gives it an automatic name based on the trendline type and the associated series. The Trendline Name setting lets you replace that automatic label with wording that makes sense to someone reading the chart.
The name is most visible in the chart legend. With a legend turned on, Excel lists the plotted series and, where applicable, the trendline as separate entries. A useful custom label can distinguish several lines that would otherwise have similar automatic names, such as Linear (Revenue) and Linear (Costs). If no legend is shown, changing the name may appear to do nothing; the name has changed, but there is no legend entry on the chart to display it.
Renaming does not change the underlying data series name. To rename a series, select the chart and use Chart Design > Select Data, choose the series in the list, and select Edit. The series name can be linked to a worksheet cell or entered as text. That name identifies the data plotted in the chart; the custom trendline name identifies the fitted line.
It also does not change a trendline equation or its R-squared value. If you have displayed either on the chart, those are separate labels and options. In the Format Trendline pane, options such as Display Equation on chart and Display R-squared value on chart control those items. Renaming the line is not a way to edit the equation or improve the fit.
Show the name in the chart legend
If you want readers to see the custom name, make sure the chart has a legend. Select the chart, then choose Chart Design > Add Chart Element > Legend and select a position such as Right or Bottom. In some Excel layouts, selecting the chart also shows a plus-shaped Chart Elements button beside it; its Legend option can turn the legend on. The exact controls depend on the chart and the available window space.
After enabling the legend, check whether the trendline entry is included. A legend can be present while the particular item you expect is not obvious, especially when the chart contains several series or trendlines. If the custom text does not appear, reselect the trendline and confirm that Custom is selected and that the text was entered in the Trendline Name box. Click outside the box or press Enter to commit the edit.
Keep legend labels short enough to scan. A phrase such as 2025 demand trend is usually more helpful than a full explanation. Put longer context in the chart title, subtitle, or a nearby note. This keeps the legend from taking over the plot area, particularly when several trendlines share the same chart.
Select the right trendline when a chart has several
Charts with multiple data series can have multiple trendlines, and each trendline has its own name setting. Make sure you format the intended line rather than the data series or a different trendline. A quick way to check is to select an item and look at the heading in the Format pane; it should identify the selected object as a trendline.
If clicking the line is unreliable, select the chart and use the Current Selection list on the contextual Chart Format tab. Choose the appropriate trendline from the list, then open Format Selection. The list can include chart elements with similar names, so use the series association or trendline type to identify the right one. You can also click the legend entry for a trendline when it is visible, then open its formatting options.
For example, a chart comparing actual sales in two regions may have one linear trendline for each region. Give the lines distinct labels such as North region trend and South region trend rather than naming both Sales trend. That distinction makes the legend useful without changing which points each line is calculated from. If you change the underlying chart data or add another series later, check that each trendline still belongs to the intended series.
Choose labels that explain the chart
A good trendline name tells the reader what the line represents, not merely what kind of calculation Excel used. The automatic word Linear can be useful to a technical audience, but it may not explain the business meaning. Conversely, a label should not imply certainty or causation that the chart does not establish.
- For a monthly chart, use a period or subject, such as Monthly orders trend.
- For a comparison chart, identify the group, such as East region forecast trend.
- If the model type matters, include it concisely, such as Linear fit, rather than hiding it in a long sentence.
- Use consistent wording across charts in a report so readers can compare them quickly.
Be careful with terms such as forecast. A trendline fitted to existing chart data is not automatically a validated forecast. Excel’s Forecast Forward setting can extend some trendlines beyond the observed data, but the extension is a mathematical projection based on the selected trendline type. Naming a line Forecast does not test whether its assumptions are appropriate.
Common problems and how to fix them
The Trendline Name setting is missing. The selected object may be the chart area, a data series, or an axis rather than the trendline. Click the trendline or choose it from Current Selection, then reopen the Format Trendline pane. The options shown depend on the selected chart element.
The name changes, but the legend does not. Confirm that the legend is turned on and that you edited the trendline rather than the series. Also check that you selected Custom, entered the text in the name box, and confirmed the edit. If the chart has a crowded legend, the text may be present but clipped or difficult to notice; widen the chart or move the legend.
The equation still shows the old wording. That is expected. A displayed equation is a separate chart label and contains the fitted equation, not the trendline name. If you want to change how readers interpret the equation, add an explanatory text box or revise the chart’s supporting text; renaming the trendline will not rewrite it.
I cannot select the trendline. Try selecting it through the Current Selection list instead of clicking the plot. If the trendline is not listed, check that it has actually been added to the chart and that the chart type supports that trendline option. Excel does not offer trendlines for every chart type. If the chart’s data or type has changed, the line may have been removed or may no longer be available.
The custom name is not retained. Enter the text in the Custom name box and press Enter before closing the pane. If the workbook is read-only or editing is restricted, you may not be able to save the change. Save the workbook after making the edit, and verify the result by closing and reopening the file if the label is important for a report.
Excel for Mac and Excel for the web
In Excel for Microsoft 365 on Mac, the same basic setting is available in the trendline formatting controls: select the chart’s trendline, open Format Trendline, and choose Custom under Trendline Name. A Control-click or right-click can open the context menu, depending on the Mac’s mouse or trackpad settings. Ribbon tab names and pane placement can differ from Windows, but the setting is attached to the trendline rather than to the worksheet cells.
Excel for the web may show a more limited set of chart-formatting controls than the desktop application, and the available options can change as Microsoft updates the service. If you cannot find Trendline Name or the Custom choice in the web pane, open the workbook in the Excel desktop app and make the change there. The custom label is a workbook chart setting, so after saving, check the chart again in the version where it will be presented.
Frequently Asked Questions
Can I rename a trendline without changing the data series name?
Yes. Select the trendline and set a Custom Trendline Name. The data series name is a separate chart setting under Chart Design > Select Data, so changing one does not rename the other.
Why does my custom trendline name not appear?
The most common reason is that the chart legend is hidden. Turn it on using Chart Design > Add Chart Element > Legend. If it is already visible, verify that you changed the trendline name rather than the series name and that Custom is selected.
Can I rename a trendline in the legend directly?
Use the Format Trendline pane and its Custom name box rather than editing the legend text. A legend entry reflects the name of its chart element; editing the trendline’s setting is the reliable way to change that label.
Can each trendline have a different name?
Yes. Each trendline has its own formatting options. Select each one in turn, choose Custom, and enter a distinct label so the legend identifies which series each line belongs to.
Does renaming a trendline change its equation or forecast?
No. The name is a display label only. It does not alter the trendline type, calculated equation, R-squared value, data, or any forward projection settings.
Related
- Named Range in Excel: Definition, Uses, and Examples
- Multiple Goal Seek in Excel: What Works and What Doesn’t
- Multiple Text to Columns in Excel: Methods That Work
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Chart Tutorial: Create and Customize ChartsTo create a chart in Google Sheets, select the cells containing your data, choose Insert > Chart, then…
- Excel Dashboard Software Templates: How to Choose and UseExcel dashboard software templates are ready-made workbooks that turn spreadsheet data into a visual summary, usually with charts,…
- BI with Excel Power Pivot: Models, Reports, and LimitsYes—Excel Power Pivot can support business intelligence (BI) by combining data from multiple sources into a relational data…
- Excel Graph Axis Labels: Add, Edit, and FormatIn Excel, axis labels are the category names or scale values shown beside a chart’s horizontal or vertical…
- Excel Group Rows by a Column: Sort, Outline, or PivotYes. To group records by a column in Excel, sort the rows by that column and use Data…
- Excel Pivot Table Calculated Field Filter ExplainedYes, you can filter a PivotTable based on a calculated field’s results, but usually you do it with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.