O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required