Point and Points Members
Use the Points collection to get individual data points from a series. Use the Series object’s Points property to get a reference to this collection. Use the Point object to change the appearance of a point within a series. The Points collection and Point object have the following members. The key member (shown in bold) is covered in the following reference section:
|
1 Collection only | |
|---|---|
|
2 Object and collection | |
|
Application 2 |
ApplyDataLabels |
|
ApplyPictToEnd |
ApplyPictToFront |
|
ApplyPictToSides |
Border |
|
ClearFormats |
Copy |
|
Count 1 |
Creator 2 |
|
DataLabel |
Delete |
|
Explosion |
Fill |
|
HasDataLabel |
Interior |
|
InvertIfNegative |
Item 1 |
|
MarkerBackgroundColor |
MarkerBackgroundColorIndex |
|
MarkerForegroundColor |
MarkerForegroundColorIndex |
|
MarkerSize |
MarkerStyle |
|
Parent 2 |
Paste |
|
PictureType |
PictureUnit |
|
|
Select |
|
Shadow |
Most of the Point members are also available on the Series object. When those members are applied on the Point object, they affect a single point rather than the entire series. See the Series reference topics for complete information and examples of how to use those members.
Only the SecondaryPlot property is unique to the Point object, so it is covered here.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
