Excel.Points(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Points object (Excel)	vbaxl10.chm573072	vbaxl10.chm573072	Excel.Points	918dc385-ed61-262e-033f-ba829f5ee8b2	03/30/2019	medium

Points object (Excel)

A collection of all the Point objects in the specified series in a chart.

Remarks

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.

Example

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

Methods

• Item

Properties

• Application
• Count
• Creator
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]