Excel 2007: How To Add a Trendline to a Chart
Contributed by Rob Rogers 
Tagged: Microsoft Excel 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.
You may also like -
Excel 2007: Advanced Chart Labeling
Excel: How To Copy Formatting From One Chart To Another
Excel 2007: Have Your Data Read Back To You
Microsoft Excel 2003: How To Disable Chart Tips
Excel 2007: How to Sort Rows
Excel: How To Insert Organization Diagrams and Charts
Excel: Prevent Conversion of URLs into Hyperlinks
Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet
color_chart said on November 6, 2008
very useful thank you very much :)
Gary said on November 11, 2008
Not e: this only works with 2D charts. Excel won’t let you add a trendline to a 3D chart type
poo said on November 13, 2008
i love you thx !!!!!
excel is bad said on December 4, 2008
great explenation!
d said on April 14, 2009
thanks a lot!
drowing_in_stats said on June 20, 2009
Worked perfectly; thanks :)
Gazza said on October 7, 2009
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
Anonymous said on November 18, 2009
Trendline for polynomial is having a factor E in it. What is it? Can someone explain.
I appreciate your help on this. Thanks.
Jaclyn said on May 24, 2010
Thank you for adding that extra bit of info about the 3D charts! I was about to pull my hair out! LOL
rackmanager said on May 27, 2010
I don’t have trend line button on the ribbon tab.How to get the trend line in there?
TBright163 said on July 14, 2010
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.
Borech911 said on September 17, 2010
Большое спасибо очень помогло:))))))))))
J5girl_89 said on October 16, 2010
My data looks very logorithmic, but it won’t allow me to use that trendline, why???
Cumbestwesley said on February 17, 2011
does anyone know how to add a trend line on excel 2008 for mac???
Dale Mackay said on June 5, 2011
Excel 2007 I don’t have trend line button on the ribbon tab.How to get the trend line in there
Joe Camilleri said on November 2, 2011
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
Joe Camilleri said on November 2, 2011
Sorry….in previous post, I meant to say re Excel 2010……net 2007
Joe
Tom Fraser said on November 5, 2011
The trendline option is grayed out. How do I get it to be selectable?
Tom