General information
Category:
COM/DCOM and OLE Automation
Cetin - Thanks that did it.
I was trying to use "type" in the command and never got it to work.
Gaylen
>>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
>>.charts('chart1').datalabels.type = 2
>>.charts('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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only