Share via

Trendlines Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns the ChTrendlines collection for the specified series. Note that a series can have only one trendline.

expression.Trendlines

expression   Required. An expression that returns a ChSeries object.

Remarks

For information about returning a single member of a collection, see Returning an Object from a Collection.

Example

This example adds a trendline to the specified series and then hides the trendline’s R-squared value.

  Sub AddTrendline()

   Dim serSeries1

   ' Set a variable to the first series in the first chart of Chartspace1.
   Set serSeries1 = ChartSpace1.Charts(0).SeriesCollection(0)

   ' Add a trendline to the series.
   serSeries1.Trendlines.Add

   ' Hide the R Squared value for the trendline.
   serSeries1.Trendlines(0).IsDisplayingRSquared = False

End Sub