Table of contents
Collapse the table of content
Expand the table of content

Trendline.Type Property (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns or sets the trendline type. Read/write XlTrendlineType.


expression. Type

expression A variable that represents a Trendline object.


Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

The following example changes the trendline type for the first series of the first chart in the active document. If the series has no trendline, this example fails.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        .Chart.SeriesCollection(1).Trendlines(1).Type = xlMovingAvg

    End If

End With

See also


Trendline Object

© 2018 Microsoft