Class SparkAxes (Excel VBA)

The class SparkAxes represents the settings for the horizontal and vertical axes of a group of sparklines. To use a SparkAxes class variable it first needs to be instantiated, for example

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

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