Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel automaion
Message
From
04/06/2001 12:37:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/06/2001 12:11:20
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00514642
Message ID:
00514663
Views:
10
This message has been marked as the solution to the initial question of the thread.
>I would like to add values to a line graph prepared by vfp and excel. I got everthing working except the right code to trigger adding values. Chart type 4.
>
>The macro code is :
>activechart.applydatalabels Type:=xldatalabelsshowvalue, legendkey: = False
>
>I have used all variations of
>.chart('chart1').datalabels.type = 2
>.chart('chart1').datalabelstype = 2
>
>I could convert most of the code for the data selection and chart from the macro's and other resource materials, but I confess I am stuck here.
>
>
>Thanks in advance for any help!!
>Gaylen Jungling

Gaylen,
.charts('chart1').applydatalabels(xldatalabelsshowvalue)

PS: Charts() and ChartObjects() are different collections.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform