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

Points Object (PowerPoint)

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

A collection of all the Point objects in the specified series in a chart.

Remarks

Use Points ( Index ), where Index is the point index number, to return a single Point object. Points are numbered from left to right on the series. Points(1) is the leftmost point, and Points(Points.Count) is the rightmost point.

Example

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

Use the Points method to return the Points collection. The following example adds a data label to the last point in series one for the first chart in the active document.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        With .Chart.SeriesCollection(1).Points

            .Item(.Count).ApplyDataLabels Type:=xlShowValue

        End With

    End If

End With

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

The following example sets the marker style for the third point in series one for the first chart in the active document. The specified series must be a 2-D line, scatter, or radar series.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        .Chart.SeriesCollection(1).Points(3).MarkerStyle = xlDiamond

    End If

End With

See also

Concepts

PowerPoint Object Model Reference

© 2017 Microsoft