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

Similar Threads

Excel 2007 chart line width + axis labelling with VBA 6
macro to keep chart dual axis format 1
Using the full width of an Excel chart with two Y-axes 2
Editing secondary x-axis 1
VB for Chart Axis 1
VBA to identify the name of a point 3
VBA to identify the name of a point 3
Formatting 'X' Axis -- 2 fundamental differences 7

Top