thanks,

I recored a macro and looked at the code and am trying to get it to work in vfp. I have gotten to the point where i am trying to set the source data(the code attached to this and the last message) I can't seem to get the syntax right, I have played around with it to no avail. Thanks for the help.

James

ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B4"), PlotBy:= _
xlcolumns