HasAxis Property

Applies To

Chart Object.

Description

Indicates which axes exist on the chart, as a two-dimensional array of Boolean values. Read-write.

The first array dimension indicates the axis (one of xlCategory, xlValue, or xlSeries). Series axes apply only to 3-D charts.

The second array dimension indicates the axis group (xlPrimary or xlSecondary). Read-write. 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.

Example

This example turns on the primary value axis for Chart1.


Charts("Chart1").HasAxis(xlValue, xlPrimary) = True