Excel 2007: How To Add a Trendline to a Chart

Trendlines are useful for revealing patterns or trends in your data. They are mostly used in XY scatter charts but are also useful in line, area, and bar charts. To add a trendline to your chart, follow these instructions…


1. Select the chart.

2. Select the series you wish to use to create the trendline.

3. Go to Chart Tools, select the Layout tab and click Trendlines.

4. Select the type of relationship you are expecting the data to reveal, your choices are Linear, Exponential, Linear Forecast, or Two Period Moving Average. You can also select More Trendline Options to reveal even more types.

5. Right-click the newly created trendline and select Format Trendline. Use the Line Color, Line Style and Shadow sections to modify the look of the trendline.

6. Click Close.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

19 Responses to “Excel 2007: How To Add a Trendline to a Chart”

  1. November 06, 2008 at 12:00 pm, color_chart said:

    very useful thank you very much :)

    Reply

  2. November 11, 2008 at 3:15 pm, Gary said:

    Not e: this only works with 2D charts. Excel won’t let you add a trendline to a 3D chart type

    Reply

    • May 24, 2010 at 12:23 am, Jaclyn said:

      Thank you for adding that extra bit of info about the 3D charts! I was about to pull my hair out! LOL

      Reply

  3. November 13, 2008 at 9:39 am, poo said:

    i love you thx !!!!!

    Reply

  4. December 04, 2008 at 3:07 pm, excel is bad said:

    great explenation!

    Reply

  5. April 14, 2009 at 3:47 pm, d said:

    thanks a lot!

    Reply

  6. June 20, 2009 at 4:19 pm, drowing_in_stats said:

    Worked perfectly; thanks :)

    Reply

  7. October 07, 2009 at 8:27 pm, Gazza said:

    Why is the help so much worse than previous versions.

    Its pretty sad really. I’ve noticed this with MS products over the last few releases. Google out performs help on all levels from low end user apps to server products.

    A excel help search, brings up the mathmatical theory behind trend lines!

    thanks for posting this though cheers

    Reply

  8. November 18, 2009 at 1:10 pm, Anonymous said:

    Trendline for polynomial is having a factor E in it. What is it? Can someone explain.
    I appreciate your help on this. Thanks.

    Reply

  9. May 27, 2010 at 7:05 am, rackmanager said:

    I don’t have trend line button on the ribbon tab.How to get the trend line in there?

    Reply

    • July 14, 2010 at 6:19 pm, TBright163 said:

      I think you have to select the axis you want to use to add the trend line to, then you can select the Layout menu and find the trend button.

      Reply

  10. September 17, 2010 at 9:24 am, Borech911 said:

    Большое спасибо очень помогло:))))))))))

    Reply

  11. October 16, 2010 at 9:29 pm, J5girl_89 said:

    My data looks very logorithmic, but it won’t allow me to use that trendline, why???

    Reply

  12. February 17, 2011 at 3:35 am, Cumbestwesley said:

    does anyone know how to add a trend line on excel 2008 for mac???

    Reply

  13. June 05, 2011 at 10:37 am, Dale Mackay said:

    Excel 2007 I don’t have trend line button on the ribbon tab.How to get the trend line in there

    Reply

  14. November 02, 2011 at 6:01 am, Joe Camilleri said:

    I have 2 major problems with SOME date/value charts in Excel 2007
    (a) the moving average plots before the last data point, e.g. in range of 10 dates/values, the trendline for a 3 deep MAV is plotted along points 2 to 8 only.
    (b) if the data series is vertical and in descending date order, so I can only get a left-to-right history in the plot if I ‘reverse’, which then shifts the value scale (y-axis) to the right of the chart. How can I have both the axis on the left hand side and the left-to-right history?

    Grateful for any help from anyone.

    Joe

    Reply

  15. November 02, 2011 at 6:07 am, Joe Camilleri said:

    Sorry….in previous post, I meant to say re Excel 2010……net 2007

    Joe

    Reply

  16. November 05, 2011 at 3:53 pm, Tom Fraser said:

    The trendline option is grayed out. How do I get it to be selectable?
    Tom

    Reply

  17. March 30, 2012 at 3:56 am, inder said:

    like it

    Reply

Leave a Reply