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

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


Returns the SparkHorizontalAxis object for the specified SparkAxes object.

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


Returns the SparkVerticalAxis object for the specified SparkAxes object.

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