Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Again with excel Graph automation
Message
From
14/12/2007 06:49:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Again with excel Graph automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01275801
Message ID:
01275801
Views:
54
Hi there,
I have problems with putting labels on grid AXIS.
I have from the Excel Macro
 ActiveChart.SeriesCollection(1).XValues = "='MySheetName'!R2C2:R12C2"
ActiveChart.SeriesCollection(2).XValues = "='MySheetName'!R2C2:R12C2"
ActiveChart.SeriesCollection(3).XValues = "='MySheetName'!R2C2:R12C2"
but i don't know how to translate the R-C notation. It's obviously referred to Rows and columns but i don't know how to invoke it from VFP.
Could you help me again please ?
Thanks again
Alessio
Next
Reply
Map
View

Click here to load this message in the networking platform