Primary Axis Position

G

George Lee

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.
 
A

Andy Pope

Hi,

Try,

ActiveChart.Axes(xlCategory).AxisBetweenCategories = False

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top