>>I think Flores' answer is excellent; I use that method(?) too.
>>However I have more tip and question about implementing M.S graph.
>>
>>Tip1.
>> ** Using Autoformat property.
>>
>> If there is no predefined max value of data series, that is to say whenever a your makes
>> graph in applications the max value fluctuate emensely, user may get stupid graphs that
>> every data value for graph exceed the max limit of predefined graph in Gen field.
>>
>> Autoformat property can solve this problem.
>>
>> < code omitted >
>>
>> Use Utiltable
>> Append General gen_1 DATA m.Cgdata ** m.Cgdata ; data series
>>
>> Thisform.oleboundcontrol1.ControlSource = " gen_1"
>>
>> Thisform.oleboundcontrol1.autoformat(n,m)
>>
>> The combination of numbers n,m in autoformat(n,m) decide which types of graph it would be
>> and you don't have to worry about the value of X,Y axies. But the combination is also predefined
>> that if you issue the wrong combination it can cause an error.
>>
>>Tip2. Covering Oleobject with transparent shape object.
>> This can prevent users from making dubleclick event on the Oleobject; in case Activating
>> Ole server application is not desirable.
>>
>>My Question.
>>
>> A client PC has no M.S graph and M.S graph runtime is included in the setup procedure. But
>> the graph in application is not working. Does anyone know why ?
>>
>> Thanks in advance.
>
>I Sent this message earlier, but I am afraid it didn't go out. So, forgive if this is a rerun.
>
>First of all, thanks for all the help. I am well on my way with the tips you guys have given. Does anyone know how to format the color of a data series programatically? Help...
>
>John Dennis

Color Property Example taken from \windows\msapps\msgraph5\vba_grp.hlp

This example sets the color of the tick labels for the value axis.

myChart.Axes(xlValue).TickLabels.Font.Color = RGB(0, 255, 0)

Color property applies to objects Border, Font and Interior.