Expand Minimize
This topic has not yet been rated - Rate this topic

HasAxis Property

Office 2010

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

expression.HasAxis(Index1, Index2)

expression Required. An expression that returns one of the objects in the Applies To list.

Index1Optional
XlAxisType
. The type of axis.

XlAxisType can be one of these XlAxisType constants.

xlCategory

xlValuexlSeriesAxis. Series axes apply only to 3-D charts.

Index2Optional
XlAxisGroup
. The axis priority.

XlAxisGroup can be one of these XlAxisGroup constants.

xlPrimary

xlSecondary 3-D charts have only one set of axes.

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

This example turns on the primary value axis.

myChart.HasAxis(xlValue, xlPrimary) = True
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.