>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