As you have seen in many charts it shows the overall trend or pattern or direction from the existing data points.

Excel provides the option of plotting the trend line to the chart.

When we add this trend line to the chart it looks like a line chart but without any ups and downs.

Before we add a trend line just remember what are the charts that support the trend line in excel.

We can add a trend line to a column chart, line chart, bar chart, scattered chart or XY Chart, Stock Chart, Bubble Chart in excel.

Select the chart it will show the PLUS icon on the right side.

At the end of the options, we can see the Trend Line option, click on this to add a trend line.

If you have inserted the LINE CHART in place of COLUMN CHART all the steps are the same as inserting the Trend Line in excel.

Another way is to select column bars and right-click on the bars to see options.

This is the best-fit trend line to show whether the data is trending upwards or downwards.

One of the other popular trend lines is the Moving Average Trend Line.

This will add the trend line for the average of every 2 periods.

In the formatting trend line window choose FILL LINE, make width 2 pt, and color to dark blue.

Trendline For Selected Data Points Excel How To Add And

Here we learn how to add and insert the trend line in excel along with examples and downloadable excel template.

Trendline For Selected Data Points Excel Mac