Add Trend Line in Excel

In this article, we will learn how we can add a trend line in a chart in Microsoft Excel 2010.

Let’s take an example to understand how we can add the trend line.

We have sales performance data in which we have the agents name and the amount of achieved sales. To insert a horizontal average line in the Chart, follow the below given steps:-
img1

 

  • Select the range of data, go to the insert tab, click on column chart and click on 2D chart.

img2

 

  • After inserting the chart, two contextual tabs will appear namely, “Design” and “Format”.

img3

 

  • From the “Design” tab, choose the “Chart Style”.

img4
img5

 

  •  To add the Trend line in the chart, just right click with the mouse on the series of sales amount.

img6

 

  • You will get pop up. Now, click on Add Trend line option.
  • A trend line will appear on the chart.

img7

 

This is the way we can add the Trend line in the Chart.

xlsx-1567

Download – Excel Tredline – xlsx

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube