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