Axes and Axis Members

Use the Axes collection to get the axes from a chart. Use the Chart object’s Axes property to get a reference to this collection. Use the Axis object to control the scale, caption, plot order, and appearance of an axis. The Axes collection and Axis object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only

 

2 Object and collection

 

Application 2

AxisBetweenCategories

AxisGroup

AxisTitle

BaseUnit

BaseUnitIsAuto

Border

CategoryNames

CategoryType

Count 1

Creator 2

Crosses

CrossesAt

Delete

DisplayUnit

DisplayUnitCustom

DisplayUnitLabel

HasDisplayUnitLabel

HasMajorGridlines

HasMinorGridlines

HasTitle

Height

Item 1

Left

MajorGridlines

MajorTickMark

MajorUnit

MajorUnitIsAuto

MajorUnitScale

MaximumScale

MaximumScaleIsAuto

MinimumScale

MinimumScaleIsAuto

MinorGridlines

MinorTickMark

MinorUnit

MinorUnitIsAuto

MinorUnitScale

Parent 2

ReversePlotOrder

ScaleType

Select

TickLabelPosition

TickLabels

TickLabelSpacing

TickMarkSpacing

Top

Type

Width

 

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