Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Charts > VBA Code > Trendlines< Previous | Next > 


 

A trendline shows a trend or direction of data in an individual series

 
 

You can add multiple trendlines to a single series

 

 

Trendlines Collection

 
 

This contains all the Trendline objects for a single series

 


 
1
objChart.SeriesCollection(1).Trendlines(1).Type = xlTrendlineType.xlLinear
   


 
2
3
4
5
6
objChart.SeriesCollection(1).Trendlines.Add(Type:=xlTrendlineType.xlLinear, _
                     Forward:=0, _
                     Backward:=0, _
                     DisplayEquation:=False, _
                     DisplayRSquared:=False)
   



 
7
objChart.SeriesCollection(1).Trendlines(1).Delete
   



 © Better Solutions Limited 10-May-2013< Previous | Top | Next >