Chart & Visualization Issues

Add a Trendline in Excel When Chart Elements Is Missing

Natalie TaylorNatalie Taylor Nov 13, 2026 869 views

Question details

Add a trendline to an Excel scatter plot when the Chart Elements button is missing and determine whether the issue affects other charts or workbooks.

How to Add a Trendline When Excel's Chart Elements Button Is Missing
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to add a trendline to a scatter plot but cannot find the Chart Elements control.
Observed behavior
The Chart Elements button is missing from the chart.
Before you start

Open the workbook and select the scatter plot so Excel displays its chart-specific commands. Make sure the chart contains a data series to which a trendline can be added.

Solution 1Recommended

Add the Trendline from the Chart Design Tab

Use the ribbon command when the Chart Elements button is not visible beside the chart.

1
Select the chart

Click the scatter plot to display the Chart Design tab on the ribbon.

2
Choose a trendline

Open Chart Design > Add Chart Element > Trendline, then select the trendline type you need.

3
Choose a data series if prompted

If Excel asks which series to use, select the series and confirm your choice.

Add the Trendline from the Chart Design Tab
Check the chart type: Trendline availability depends on the chart type. For a scatter plot, make sure a valid data series is present.
Free Microsoft Office alternative

Create and Edit Spreadsheet Charts with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheets and charts. Open compatible Excel files in WPS Spreadsheets for an easier transition; it does not repair missing controls in Microsoft Excel.

Create and edit spreadsheet charts, including scatter plotsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for a smoother transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I add a trendline without the Chart Elements button?

Yes. Select the chart and choose Chart Design > Add Chart Element > Trendline, then select a trendline type.

Why is the Trendline option unavailable?

Availability depends on the chart type and its data. Check that the scatter plot has a valid data series, then test another chart and workbook to see whether the issue is broader.

How do I check for Excel updates?

In Excel for Windows, go to File > Account > Update Options > Update Now. You can also select About Excel on the Account page to check your version.

What should I do if the trendline command is missing in every workbook?

After checking for updates, contact Microsoft Support or your IT administrator. Provide your Excel version and explain that you tested charts in more than one workbook.