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.
Charts("Chart1").SeriesCollection(1) _
.Trendlines(1).NameIsAuto = True