Edit

Share via

SparkPoints Interface

  • Reference

Definition

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

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