[RESOLVED] Chart label on tick marks

I've searched and searched and cannot find any examples of VBA setting the x axis (Axes(xlCategory)) so that the axis labels are on the tick mark (not between). Any help would be appreciated.

Not sure which version you are using?

In Excel 2007, you do it this way...

Code:

---

    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).AxisBetweenCategories = False

---

Thank you very much. It worked.