Tim,
I don't understand why it is the only thing you can change. You certainly can access and change datasheet.
Cetin
>Cetin,
>
>We created this graph using the graph wizard in vfp 7. The data string in the graph is the only thing that we can change, VFP does not give us access to the datasheet when doing this. I have been able to fix the problem by adding in the follwing command to the append line:
>
>APPEND GENERAL OLEGRAPH2 CLASS "msgraph.chart.8" DATA cGraphString
>
>By adding the CLASS "msgraph.chart.8" to the string it changes the expected look of the graph. We now have the account number to the side and it skips the monthly headers at the bottom of the graph. Before we just had the monthly headers for all months and the usage on the left axis.
>
>Thank you for the quick response. It led to another area to check, but...I'm still looking for a fix for now.
>
>
>Thank You
>Tim
>
>
>>(It has been a long time I didn't use MSGRaph and my suggestion might not help)
>>Instead of append general try directly changing MSgraph object's datasheet. ie:
>>
>>local ix
>>with thisform.myGraph.object.application.datasheet
>> .Cells.Clear
>> for ix=1 to fcount()
>> .Cells(1,m.ix).Value = field(m.ix)
>> endfor
>> scan
>> for ix=1 to fcount()
>> .Cells(recno()+1,m.ix).Value = evaluate(field(m.ix))
>> endfor
>> endscan
>>endwith
>>
>>Cetin
>>