Primary Axis Position
 

I hate asking such as referenial question, but I can't find this online: How
do you set the Position Axis through VB/VBA?

That is, in the Format Axis dialog (right click a chart X axis and select
Format Axis...) there is an option to "Position Axis" as either "On tick
marks" or "Between tick marks". How can this be set programmatically? No, the
macro recorder does this record this.

Primary Axis Position
 

Hi,

Try,

ActiveChart.Axes(xlCategory).AxisBetweenCategories = False

Cheers
Andy

George Lee wrote:
I hate asking such as referenial question, but I can't find this online: How
do you set the Position Axis through VB/VBA?

That is, in the Format Axis dialog (right click a chart X axis and select
Format Axis...) there is an option to "Position Axis" as either "On tick
marks" or "Between tick marks". How can this be set programmatically? No, the
macro recorder does this record this.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info