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