excel - make chart axis position low - vba -

excel - make chart axis position low - vba -

the default x-axis position of charts made vba in middle. how create axis on chart show on bottom?

my current code:

activesheet.shapes.addchart.select activechart.setsourcedata source:=range("i3", sheets("main").range("l3").end(xldown).address) activechart.charttype = xlline activechart.parent .height = 400 .width = 800 end

just utilize ticklabelposition property of axis:

activechart.axes(xlcategory).ticklabelposition = xlticklabelpositionlow

excel vba excel-vba