SparkPoints Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: GuidAttribute InterfaceTypeAttribute

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	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	Gets a 32-bit integer that indicates the application in which this object was created.
Firstpoint	Gets a SparkColor object that represents the color and visibility of the marker for the first point of data on a sparkline.
Highpoint	Gets a SparkColor object that represents the color and visibility of the marker for the highest point of data on a sparkline.
Lastpoint	Gets a SparkColor object that represents the color and visibility of the marker for the last point of data on a sparkline.
Lowpoint	Gets a SparkColor object that represents the color and visibility of the marker for the lowest point of data on a sparkline.
Markers	Gets a SparkColor object that represents the color and visibility of markers for positive points of data on a sparkline.
Negative	Gets a SparkColor object that represents the color and visibility of markers for negative points of data on a sparkline.
Parent	Gets the parent SparklineGroup object for the specified object.

Applies to