Thread: Trendline
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Trendline

Select and right click each of the series in turn
Select 'Add Trendline'
Select the line type
Click OK

Mike

"Carlo" wrote:

How do I create multiply trendlines on one graph. I have 5 years data on one
graph and I want to show a linear trendline for each year on the one graph?
Thanks