GrapeCity.Documents.Excel.ISparkVerticalAxis

ISparkVerticalAxis Interface

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

Use this interface to configure the minimum and maximum scale behavior for sparkline vertical axes, including custom axis bounds and scaling options relative to other sparklines in the same group.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISparkVerticalAxis

Public Interface ISparkVerticalAxis

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{10}, {-5}, {20}};
ISparklineGroup sparklineGroup = worksheet.Range["B1:B3"].SparklineGroups.Add(SparkType.Line, "A1:A3");
ISparkVerticalAxis verticalAxis = sparklineGroup.Axes.Vertical;
verticalAxis.CustomMinScaleValue = -10;
verticalAxis.CustomMaxScaleValue = 25;

Properties

Name	Description
CustomMaxScaleValue	Gets or sets the custom maximum value for the vertical axis of a sparkline. Use this property to set or retrieve the manual maximum axis value after the maximum scale type has been set to SparkScaleCustom.
CustomMinScaleValue	Gets or sets the custom minimum value for the vertical axis of a sparkline. Use this property to set or retrieve the manual minimum axis value after the minimum scale type has been set to SparkScaleCustom.
MaxScaleType	Gets or sets how the maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. Use this property to determine whether the sparkline group's vertical axis maximum is calculated per sparkline, shared across the group, or defined by a custom value through CustomMaxScaleValue.
MinScaleType	Gets or sets how the minimum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. The returned SparkScale value indicates whether the minimum axis value is shared by the sparkline group, calculated for each sparkline, or defined by a custom value.