Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graphing with Excel Automation
Message
From
06/03/2003 15:33:31
 
 
To
06/03/2003 10:03:47
Stan Vaninger
Mitek Industries, Inc
Missouri, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00762164
Message ID:
00762426
Views:
13
Hi Stan.

I have been using the excellent material in chapter 6 of the 'MegaFox' book and in the 'MS Office Automation with VFP' book to do some graphing

I hope that you are enjoying the book!

Everything on the graphs looks great except for the ChartTitle and the Legend; in both cases the text characters are squeezed together making it difficult to read.

What you may want to try is to create your own legends and Chart Tiles in the report form and Set oGraph.HasTitle and oGraph.HasLengend to false. That way you have total control over where they are and how they look. You already have the data avaliable to do this. The legend entry labels are either the field names in the underlying cursor or the descriptions in the first column of the data (depending on whether you are plotting the series from the data in the columns or the rows). You can get the color for each series object by accessing oGraph.SeriesCollection( < index > ).Interior.Color

Yes, it means that you have to write more code. But if you keep it generic and use the data that you already have, the good news is that you only have to write it once < s >.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform