Points Object

Remarks

Use Points(), where is the point index number, to return a single Pointobject. 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

Use the Points method 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 2-D line, scatter, or radar series.

Worksheets(1).ChartObjects(1).Chart. _ SeriesCollection(1).Points(3).MarkerStyle = xlDiamond

See also:

• Excel Object Model Reference
• Points Object Members