GrapeCity.Documents.Excel.ISparkHorizontalAxis

ISparkHorizontalAxis Interface

Represents the settings for the horizontal axes of a group of sparklines.

Use this interface to access horizontal axis settings for a sparkline group, such as the axis color, whether the axis uses date-based values, and whether points are plotted in right-to-left order. Instances are typically obtained from Horizontal.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISparkHorizontalAxis

Public Interface ISparkHorizontalAxis

Examples

worksheet.Range["A1:C1"].Value = new object[] {1, 3, 2};
ISparklineGroup sparklineGroup = worksheet.Range["D1"].SparklineGroups.Add(SparkType.Line, "A1:C1");
ISparkHorizontalAxis horizontalAxis = sparklineGroup.Axes.Horizontal;
ISparkColor axisColor = horizontalAxis.Axis;
horizontalAxis.RightToLeftPlotOrder = true;

Properties

Name Description

Name	Description
Axis	Gets the ISparkColor object that specifies the color and visibility of the horizontal axis of the sparkline. Use the returned ISparkColor object to access and modify the horizontal axis color and visibility settings for the sparkline group.
IsDateAxis	Gets whether the horizontal axis of the sparkline is based on date values. Returns `true` when the sparkline group uses a date range for its horizontal axis.
RightToLeftPlotOrder	Gets or sets whether the points on the horizontal axis are plotted in right-to-left order. Returns `true` when points on the sparkline horizontal axis are plotted from right to left instead of the default left-to-right order.

Axis

Gets the ISparkColor object that specifies the color and visibility of the horizontal axis of the sparkline.

Use the returned ISparkColor object to access and modify the horizontal axis color and visibility settings for the sparkline group.

IsDateAxis

Gets whether the horizontal axis of the sparkline is based on date values.

Returns true when the sparkline group uses a date range for its horizontal axis.

RightToLeftPlotOrder

Gets or sets whether the points on the horizontal axis are plotted in right-to-left order.

Returns true when points on the sparkline horizontal axis are plotted from right to left instead of the default left-to-right order.