Class SparkAxes (Excel VBA)

The class SparkAxes represents the settings for the horizontal and vertical axes of a group of sparklines.

Item

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

Dim sas as SparkAxes
Set sas = ActiveCell.SparklineGroups(1).Axes

The following procedures can be used to set variables of type SparkAxes: SparkHorizontalAxis.Parent, SparklineGroup.Axes and SparkVerticalAxis.Parent.

Horizontal

Returns the SparkHorizontalAxis object for the specified SparkAxes object.

Dim shasHorizontal As SparkHorizontalAxis
Set shasHorizontal = ActiveCell.SparklineGroups(1).Axes.Horizontal

Vertical

Returns the SparkVerticalAxis object for the specified SparkAxes object.

Dim svasVertical As SparkVerticalAxis
Set svasVertical = ActiveCell.SparklineGroups(1).Axes.Vertical