> > Something like this:
> > .....
> > o.activesheet.ChartObjects(1).Activate
> > o.activesheet.ChartObjects(1).chart.Axes(xlValue).Select
> > o.Selection.TickLabels.Orientation = xlDownward
>
> Thanks a lot Yuri, while your solution wasn't quite correct you lead me on the right path. I had just glossed over the TickLabels class. I was always looking for just labels. Here is what I did so the labels are slanted at a 45° angle and centered between the tick marks.
>
> XLChart = XLSheet.chartObjects(1).Chart
>
> WITH XLChart
> .Axes(1).tickLabels.Orientation = 45 && denotes 45°
> .Axes(1).tickLabels.Alignment = -4108 && xlCenter = 4108
> ENDWITH
>
> Thanks again...once again, foxite pulls through when most needed!
>
> Jared Baszler
> Computer Programmer
> Mid-West Seed Services, Inc.
Does "your solution wasn't quite correct" mean it was wrong somewhere or it was not exactly what you wanted? If wrong, where?