Class SparkVerticalAxis (Excel VBA)

The class SparkVerticalAxis represents the settings for the vertical axes of a group of sparklines.

Item

To use a SparkVerticalAxis class variable it first needs to be instantiated, for example

Dim svas as SparkVerticalAxis
Set svas = ActiveCell.SparklineGroups(1).Axes.Vertical

SparkVerticalAxis class variables can be set using the SparkAxes.Vertical procedure.

CustomMaxScaleValue

Returns or sets the custom maximum value for the vertical axis of a sparkline.

The CustomMaxScaleValue property can be returned or set only when the MaxScaleType property of the specified SparkVerticalAxis object is set to xlSparkScaleCustom (3).

ActiveCell.SparklineGroups(1).Axes.Vertical.CustomMaxScaleValue =

CustomMinScaleValue

Returns or sets the custom minimum value for the vertical axis of a sparkline.

The CustomMinScaleValue property can be returned or set only when the MinScaleType property of the specified SparkVerticalAxis object is set to xlSparkScaleCustom (3).

ActiveCell.SparklineGroups(1).Axes.Vertical.CustomMinScaleValue =

MaxScaleType

Returns or sets how the maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

xlSparkScaleCustom - The minimum or maximum value for the vertical axis of the sparkline has a user-defined value, xlSparkScaleGroup - The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value, xlSparkScaleSingle - The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value.
ActiveCell.SparklineGroups(1).Axes.Vertical.MaxScaleType = xlSparkScaleCustom

MinScaleType

Returns or sets how the minimum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

xlSparkScaleCustom - The minimum or maximum value for the vertical axis of the sparkline has a user-defined value, xlSparkScaleGroup - The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value, xlSparkScaleSingle - The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value.
ActiveCell.SparklineGroups(1).Axes.Vertical.MinScaleType = xlSparkScaleCustom