Points object (Excel)
A collection of all the Point objects in the specified series in a chart.
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.
Use the Points method of the Series object to return the Points collection.
The following example adds a data label to the last point on series one in embedded chart one on worksheet one.
Dim pts As Points Set pts = Worksheets(1).ChartObjects(1).Chart. _ SeriesCollection(1).Points pts(pts.Count).ApplyDataLabels type:=xlShowValue
The following example sets the marker style for the third point in series one in embedded chart one on worksheet one. The specified series must be a 2D line, scatter, or radar series.
Worksheets(1).ChartObjects(1).Chart. _ 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.