Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Jared Baszler
  Where is Jared Baszler?
 Brookings
 South Dakota - United States
 Jared Baszler
 Tags
Subject: RE: Excel automation - Label alignment in a chart
Thread ID: 22121 Message ID: 22153 # Views: 12 # Ratings: 0
Version: Visual FoxPro 7 Category: Active X Controls & OLE Automation
Date: Thursday, April 10, 2003 3:02:44 PM         
   


> > 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?


COMPLETE THREAD

Excel automation - Label alignment in a chart Posted by Jared Baszler @ 4/9/2003 8:45:05 PM
RE: Excel automation - Label alignment in a chart Posted by Yuri Rubinov @ 4/9/2003 10:19:54 PM
RE: Excel automation - Label alignment in a chart Posted by Jared Baszler @ 4/9/2003 10:51:21 PM
RE: Excel automation - Label alignment in a chart Posted by Yuri Rubinov @ 4/10/2003 3:02:44 PM