Right-click on the line of the chart, select Format, then Add Trendline. Choose the Trend type, such as Linear, to add a trendline to your chart.

A trendline shows the general direction of data points in a chart. Trendlines generally smooth out short-term fluctuations and reveal long-term patterns in a timeline. To add a trendline in Excel indicates adding single or multiple trendlines for a single or multiple series. In Excel, there are six types of trendlines you can add in a chart.

To add a trendline to this chart, simply do the following: Click on the chart to select it. Click on the ‘+’ icon to the top-right of the chart. You should see a list of Chart elements with checkboxes next to them. Check the box next to ‘Trendline’. You should now see a trendline added to your Excel scatter chart:

Excel provides a number of options to customize trendlines in charts. Let us first see how to format general settings for the trendline: Click on the chart to select it. Click on the ‘+’ icon. Hover over the ‘Trendline’ option. You should see a dropdown arrow next to this option. Click on this arrow.