Axis feature: how to switch off "crosses between categories"

[oleval]

Hi All,

my code deals with a chart object. I'd like to turn off the following feature: "Value (Y) axis crosses between categories", it is under the Scale tab in the Format Axis dialog box.

Thank you very much!

Alexander

[TrippyTom]

According to VBA Help:


AxisBetweenCategories Property
True if the value axis crosses the category axis between categories. Read/write Boolean.

Remarks
This property applies only to category axes, and it doesn't apply to 3-D charts.

Example
This example causes the value axis in Chart1 to cross the category axis between categories.
Charts("Chart1").Axes(xlCategory).AxisBetweenCategories = True


Set it to False if you want to turn it off.

[oleval]

Thank you!!!