Skip to content

Latest commit

 

History

History
41 lines (26 loc) · 1.21 KB

Excel.points(collection).md

File metadata and controls

41 lines (26 loc) · 1.21 KB
Raw
title keywords f1_keywords ms.assetid ms.date ms.localizationpriority
Points collection (Excel Graph)
vbagr10.chm5207812
vbagr10.chm5207812
b41c8f08-880e-1f4a-0456-3f77c0741bc6
04/06/2019
medium

Points collection (Excel Graph)

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

Remarks

Use the Points method to return the Points collection.

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.

Example

The following example adds a data label to the last point in series one in the chart.

Dim pts As Points 
Set pts = myChart.SeriesCollection(1).Points 
pts(pts.Count).ApplyDataLabels Type:=xlShowValue

The following example sets the marker style for the third point in series one in the chart. The specified series must be a 2D line, scatter, or radar series.

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

[!includeSupport and feedback]