View Single Post
  #2  
Old March 6th, 2009, 04:43 PM posted to microsoft.public.excel.charting
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
Default How to add a trendline in Excel 2007

Click the data series in the chart
Look in Chart Tools | Layout | Analysis for Trendline
Click the launcher (triangle pointing down) ; select the type of trendline
needed
Open the "More Trendline Options" to add equation. etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rookie Roger" wrote in message
...
I was once an expert, guru even, helped everybody. Now I can't even find
the
help menu. So very frustrating.

I have a graph and need to add a trendline. The graph is embedded in a
worksheet sitting alongside four other graphs that have trendlines i
created
with Excel 2003. Trendline is no longer a simple check box on a screen
that
i can get to. I see it on one of the menus, Trendline, all nice and
pretty
grey. There's no help on trendline using F1 key, other than giving the
formulas. On-line I find instructions on how to add a trendline, duh, and
the trendline option is grey. Would anyone mind trying to assess how I've
become so incompetent so quickly, and tell me what I'm doing wrong?