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 Excel 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 for Chart1.
Charts("Chart1").HasAxis(xlValue, xlPrimary) = True