>>Hi, Dear Cetin,
>>
>>I have read your reply to Marco on 04/02/1998 concerned with the graph in report. It is very useful for me. Thank you very much.
>>
>>There are graphType and graphsubType in your program, what are them ?
>>I want to change the chart type of the msgraph, but I don't know how to do.
>>Can you help me ?
>Graphtype and subtype are VB constants. To find them :
>-If you use MSgraph5 : Graphtypes are from 1 to 14 and generally the same order you see when you dblclick to edit a graph and select type and subtype correspond to the number within the group. To find them out by yourself, create a form with a oleboundcontrol and set its sourcetype to general field containing a graph. Add two textboxes for type and subtype and a commandbutton to change the type and subtype to newly typed values (I think I should have wrote an example code to initialize and add that gen field in that reply). This works well with MSgraph5 and values are 1-14 for type and 1-Groupcount for subtypes.
>-If you use MSgraph8 : Then you should also have Excel97. Select tools\macro\VB editor, then press F2. "Object browser" comes up. In classes locate XlChartType, then in members click on type you want. VB constant is shown beneath the window.
>Hope this helps.
>Cetin

Thank you very much,
I follow your hints and completed the application.

Clement
15 April, 1998.