How to set 'Vertical axis crosses between dates' with VBA

[vletm]

How to set 'Vertical axis crosses between dates' with VBA?
For some reason it changes 'sometimes' and it need to be always selected.

 

[Chihiro]

This?
https://msdn.microsoft.com/en-us/library/office/ff820959.aspx
I believe you are looking for CrossesAt property.

Edit: Here's very good resource for manipulating charts via VBA
http://www.globaliconnect.com/excel...area-plot-area-chart-axes&catid=79&Itemid=475

 

[vletm]

@Chihiro - thank You
Almost ... but not 'goal', not yet!
I gotta read Your 2nd link few more times.

 

[vletm]

@Chihiro - Thank You ... I found it !

Sheets(1).ChartObjects(1).Chart.Axes(xlCategory).AxisBetweenCategories = True