HasAxis Property

Applies To

Chart object.

Description

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 Graph may create or delete axes if you change the chart type or change the AxisGroup property.

See Also

Axes collection object.

Example

This example turns on the primary value axis.

myChart.HasAxis(xlValue, xlPrimary) = True