Class Axes (PowerPoint VBA)

The class Axes represents a collection of all the Axis objects in the specified chart. To use a Axes class variable it first needs to be instantiated, for example

Dim axs as Axes
Set axs = ActiveWindow.RangeFromPoint.Chart.Axes()

Count

Returns the number of objects in the collection.

Dim lngCount As Long
lngCount = ActiveWindow.RangeFromPoint.Chart.Axes.Count

Item

Returns a single Axis object from an Axes collection.

Item (Type, AxisGroup)

Dim axi As Axis
Set axi = ActivePresentation.Slides(1).Shapes(1).Chart.Axes(Type:=1)

Arguments

The following argument is required

Type (XlAxisType) - The axis type.

Possible return values are xlCategory - Axis displays categories, xlSeriesAxis - Axis displays data series, xlValue - Axis displays values.

Optional arguments

The following argument is optional

AxisGroup (XlAxisGroup) - The axis.

Possible return values are xlPrimary - The primary axis group, xlSecondary - The secondary axis group.