Point object (Excel)

Represents a single point in a series in a chart.

Remarks

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

Example

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

Methods

Name
ApplyDataLabels
ClearFormats
Copy
Delete
Paste
PieSliceLocation
Select

Properties

Name
Application
ApplyPictToEnd
ApplyPictToFront
ApplyPictToSides
Creator
DataLabel
Explosion
Format
Has3DEffect
HasDataLabel
Height
InvertIfNegative
Left
MarkerBackgroundColor
MarkerBackgroundColorIndex
MarkerForegroundColor
MarkerForegroundColorIndex
MarkerSize
MarkerStyle
Name
Parent
PictureType
PictureUnit2
SecondaryPlot
Shadow
Top
Width
IsTotal

See also

Excel Object Model Reference

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.