Trendline.NameIsAuto Property

Excel Developer Reference

True if Microsoft Excel automatically determines the name of the trendline. Read/write Boolean.

Syntax

expression.NameIsAuto

expression   A variable that represents a Trendline object.

Example

This example sets Microsoft Excel to automatically determine the name for trendline one in Chart1. The example should be run on a 2-D column chart that contains a single series with a trendline.

Visual Basic for Applications
  Charts("Chart1").SeriesCollection(1) _
    .Trendlines(1).NameIsAuto = True

See Also