Fix a Missing Linear Trendline on an Excel Chart
Question details
The user needs to add a linear trendline to an Excel chart and determine why it is not appearing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding a linear trendline to a chart's data series.
- Observed behavior
- The linear trendline does not appear; the chart type, data layout, and Excel version are not provided.
Open the workbook and identify the chart and data series you want to analyze. Check that the series contains multiple valid numeric values.
Add a Linear Trendline to the Selected Excel Data Series
Use the chart controls to add a linear trendline to the intended data series.
Click the chart, then click a data point or line belonging to the series you want to analyze.
Click the Chart Elements plus button next to the chart, select the arrow beside Trendline, and choose More Options. Alternatively, right-click the selected series and choose Add Trendline.
In the Format Trendline pane, select Linear. If Excel asks you to choose a series, select the intended series.

Check the Chart Type, Data, and Trendline Formatting
Use these checks if the Trendline option is unavailable or the line is difficult to see.
Create Spreadsheet Charts with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move existing files to WPS Spreadsheets. It does not repair a missing trendline in Microsoft Excel.

Frequently Asked Questions
Why is the Trendline option unavailable in Excel?
The chart type may not support trendlines, or a suitable data series may not be selected. Check Chart Design > Change Chart Type and try a 2-D scatter chart with numeric data.
How do I add a trendline to only one series?
Click the desired series in the chart, right-click it, and choose Add Trendline. Select Linear in the Format Trendline pane.
What if the trendline is added but I cannot see it?
Select the trendline and open Format Trendline. Under Fill & Line, choose a contrasting solid color and increase the line width. Also check that the selected series contains valid numeric values.
What information should I collect if the trendline is still missing?
Record the chart type, data layout, and Excel version, and prepare a small sample worksheet. These details can help identify whether the issue is caused by the chart, the data, or the Excel version.




