Edit

Share via

Points collection (Excel Graph)

  • Article

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

Remarks

Use the Points method to return the Points collection.

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

Example

The following example adds a data label to the last point in series one in the chart.

Dim pts As Points 
Set pts = myChart.SeriesCollection(1).Points 
pts(pts.Count).ApplyDataLabels Type:=xlShowValue

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.