SparkPoints SparkPoints SparkPoints Interface

Definition

Represents the settings of the markers for points of data on a sparkline.

public interface class SparkPoints
[System.Runtime.InteropServices.Guid("000244B8-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SparkPoints
Public Interface SparkPoints
Attributes

Remarks

Use the SparkPoints object to set the color and visibility of markers for points of data on a sparkline. Use the Points property of the SparklineGroup object to return a SparkPoints object. The properties of the SparkPoints object correspond to the settings of the High Point, Low Point, Negative Point, First Point, Last Point, and Markers check boxes in the Show section, and of the items on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Properties

Application Application Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

Firstpoint Firstpoint Firstpoint

Gets a SparkColor object that represents the color and visibility of the marker for the first point of data on a sparkline.

Highpoint Highpoint Highpoint

Gets a SparkColor object that represents the color and visibility of the marker for the highest point of data on a sparkline.

Lastpoint Lastpoint Lastpoint

Gets a SparkColor object that represents the color and visibility of the marker for the last point of data on a sparkline.

Lowpoint Lowpoint Lowpoint

Gets a SparkColor object that represents the color and visibility of the marker for the lowest point of data on a sparkline.

Markers Markers Markers

Gets a SparkColor object that represents the color and visibility of markers for positive points of data on a sparkline.

Negative Negative Negative

Gets a SparkColor object that represents the color and visibility of markers for negative points of data on a sparkline.

Parent Parent Parent

Gets the parent SparklineGroup object for the specified object.

Applies to