Want to know how to add trendlines to your Excel Charts?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

With Excel Charts, it is very easy to create Trendlines for your data.  Trendlines show which direction the trend of your data is going, and gives you the trajectory as well.

In this example, I show you how easy it is to insert a Trendline using an Excel Line Chart.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Highlight your table of data, including the column headings:

Add Trendlines to Excel Charts

Go to Insert > Recommended Charts (Excel 2013 & 2016)

Add Trendlines to Excel Charts

Go to Insert > Line > 2-D Line (Excel 2010)

Add Trendlines to Excel Charts

 

STEP 2: Select All Charts > Line > OK (Excel 2013 & 2016)

Add Trendlines to Excel Charts

 

STEP 3: Right click on the line of your Line Chart and Select Add Trendline.

Add Trendlines to Excel Charts

 

STEP 4: Ensure Linear is selected and close the Format Trendline Window

Add Trendlines to Excel Charts

 

Now you have your Trendline in your chart, and you can predict on where the trajectory is going in the succeeding periods:

Add Trendlines to Excel Charts

Add Trendlines to Excel Charts

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials

Leave a Comment

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

  • Hi Bryan, I have a bar chart for three about 6 sets of data for a period of 3 months (6 bars for each month). Also, i need to add a trend line to the existing bar chart and the trend line should appear above the bars showing a certain percentage value. I am not able to add the trend line. When i do, the line goes and sits at the bottom of the chart sticking to the bottom portion of the chart. I need some help on that.

    • Hi SRK,

      Were you able to right click on on of the bars then click Add Trendline? You should be able to add a linear trendline from there.

      Kind Regards,
      Bryan

  • I have a bar chart on which i want to display a trend line too. The trend line would show a different set of data from what the bars are showing.