Hi;

I am trying to convert an excel macro for inserting a chart into vfp code and am having a problem with the two macro lines below (the second line starts with 'PlotBy'):

ActiveChart.SetSourceData Source:=Sheets("cheqsale").Range("AB4:AB8"), _
PlotBy:=xlColumns

I have tried (and numerous other possibilities):

oExcel.ActiveChart.SetSourceData Source:=Sheets("cheqsale").Range("AB4:AB8"), _PlotBy:=xlColumns

I am using an excel.h file for constants.

Any ideas would be appreciated.

John