HasAxis Property

See Also         Example         Applies To

Returns or sets which axes exist on the chart. Read/write Variant.

Syntax

expression.HasAxis(Index1, Index2)

expression   Required. An expression that returns a Chart object.

Index1   Optional Variant. The axis type. Can be one of the following XlAxisType constants: xlCategory, xlValue, or xlSeriesAxis. Series axes apply only to 3-D charts.

Index2   Optional Variant. The axis group. Can be either of the following XlAxisGroup constants: xlPrimary or xlSecondary. 3-D charts have only one set of axes.

Remarks

Microsoft Excel may create or delete axes if you change the chart type or change the AxisGroup property.