Add a Trendline in Excel When Chart Elements Is Missing
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.

- 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.
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.
Add the Trendline from the Chart Design Tab
Use the ribbon command when the Chart Elements button is not visible beside the chart.
Click the scatter plot to display the Chart Design tab on the ribbon.
Open Chart Design > Add Chart Element > Trendline, then select the trendline type you need.
If Excel asks which series to use, select the series and confirm your choice.

Update Excel and Test Other Charts
Use these checks if the Trendline command is unavailable or does not work.
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.

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.




