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