GrapeCity.Documents.Excel.ISparkPoints

ISparkPoints Interface

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

An ISparkPoints instance provides access to the marker settings for the first, last, highest, lowest, positive, and negative data points in a sparkline. It is typically obtained from Points and used together with ISparkColor objects to control marker color and visibility.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISparkPoints

Public Interface ISparkPoints

Examples

worksheet.Range["A1:D1"].Value = new object[,] {{10, -5, 15, 8}};
ISparklineGroup sparklineGroup = worksheet.Range["E1"].SparklineGroups.Add(SparkType.Line, "A1:D1");
ISparkPoints sparkPoints = sparklineGroup.Points;
sparkPoints.Firstpoint.Visible = true;
sparkPoints.Negative.Color.Color = Color.Red;

Properties

Name	Description
Firstpoint	Gets the ISparkColor object that represents the color and visibility of the marker for the first point of data on a sparkline.
Highpoint	Gets the ISparkColor object that represents the color and visibility of the marker for the highest point of data on a sparkline. Use the returned object to configure whether the high-point marker is shown and which color it uses.
Lastpoint	Gets the ISparkColor object that represents the color and visibility of the marker for the last data point on a sparkline.
Lowpoint	Gets the ISparkColor object that represents the color and visibility of the marker for the lowest data point on a sparkline. Use the returned object to control whether the lowest-point marker is displayed and to customize its color.
Markers	Gets the ISparkColor object that represents the color and visibility of markers for positive points of data on a sparkline. Use this object to configure how positive data points are displayed in the sparkline group.
Negative	Gets the ISparkColor object that represents the color and visibility of markers for negative points of data on a sparkline. Use this object to configure how negative data points are displayed in the sparkline group.