Point Object

Description

Represents a single point in a series on the specified chart. The Point object is a member of the Points collection, which contains all the points in the specified series.

Using the Point Object

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. The following example sets the marker style for the third point in series one. For this example to work, series one must be a 2-D line, scatter, or radar series.

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

Properties

Application property, ApplyPictToEnd property, ApplyPictToFront property, ApplyPictToSides property, Border property, Creator property, DataLabel property, Explosion property, Fill property, HasDataLabel property, Interior property, InvertIfNegative property, MarkerBackgroundColor property, MarkerBackgroundColorIndex property, MarkerForegroundColor property, MarkerForegroundColorIndex property, MarkerSize property, MarkerStyle property, Parent property, PictureType property, PictureUnit property, SecondaryPlot property, Shadow property.

Methods

ApplyDataLabels method, ClearFormats method, Delete method.