Chart & Visualization Issues

Fix a Missing Linear Trendline on an Excel Chart

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

The user needs to add a linear trendline to an Excel chart and determine why it is not appearing.

How to Fix a Missing Linear Trendline on an Excel Chart
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.
Before you start

Open the workbook and identify the chart and data series you want to analyze. Check that the series contains multiple valid numeric values.

Solution 1Recommended

Add a Linear Trendline to the Selected Excel Data Series

Use the chart controls to add a linear trendline to the intended data series.

1
Select the data series

Click the chart, then click a data point or line belonging to the series you want to analyze.

2
Open the trendline options

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.

3
Choose a linear trendline

In the Format Trendline pane, select Linear. If Excel asks you to choose a series, select the intended series.

Add a Linear Trendline to the Selected Excel Data Series
Menu availability: Chart controls can vary by Excel version. If the Trendline option is unavailable, check the chart type and data series.
Free Microsoft Office alternative

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.

Create and edit spreadsheet charts in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesWork with a familiar, easy-to-use interfaceMove existing Office files into a lightweight productivity suite
microsoft office alternative - wps office

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.