Point Object

Excel Developer Reference

Represents a single point in a series in a chart.


The Point object is a member of the Points collection. The Points collection contains all the points in one series.


Use Points(


), where


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. 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.

Visual Basic for Applications
  Worksheets(1).ChartObjects(1).Chart. _
    SeriesCollection(1).Points(3).MarkerStyle = xlDiamond

See Also