Trendlines Property

  • Article

Returns the ChTrendlines collection for the specified series.

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

Applies to | ChSeries Object