GrapeCity.Documents.Excel.ISparkColor

ISparkColor Interface

Represents color and visibility settings for a sparkline point marker or horizontal axis.

Use this interface to configure the color and visibility for sparkline point markers, such as positive, negative, first, last, highest, or lowest points, or for the horizontal axis returned by Axis. Its Color and Visible members control how the associated marker or horizontal axis is displayed.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISparkColor

Public Interface ISparkColor

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {1, 3, 2},
    {4, 2, 5},
    {3, 6, 4}
};
ISparklineGroup group = worksheet.Range["D1:D3"].SparklineGroups.Add(SparkType.Line, "A1:C3");
ISparkColor sparkColor = group.Points.Markers;
sparkColor.Color.Color = Color.Red;
sparkColor.Visible = true;
ISparkColor axisColor = group.Axes.Horizontal.Axis;
axisColor.Color.Color = Color.Red;
axisColor.Visible = true;

Properties

Name	Description
Color	Gets an IFormatColor object that you can use to set the color of the associated sparkline marker or horizontal axis. Use the returned object to configure the color for the associated sparkline point marker or horizontal axis.
Visible	Gets or sets whether the associated sparkline marker or horizontal axis is visible. This property indicates whether the corresponding sparkline point marker or horizontal axis is displayed.

Name

Description

Color

Gets an IFormatColor object that you can use to set the color of the associated sparkline marker or horizontal axis.

Use the returned object to configure the color for the associated sparkline point marker or horizontal axis.

Visible

Gets or sets whether the associated sparkline marker or horizontal axis is visible.

This property indicates whether the corresponding sparkline point marker or horizontal axis is displayed.