Name

axes.[Item](Type, [AxisGroup])

Synopsis

Returns an axis from the Axes collection.

Argument

Settings

Type

The xlAxisType of the axis to return. Can be xlAxisValue, xlAxisCategory, or xlAxisSeries (3-D charts only).

AxisGroup

The xlAxisGroup of the axis to return. Can be xlAxisPrimary or xlAxisSecondary (2-D charts only).

The Axes collection is unique in using a 2-D array to contain its component objects.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial