about graph generation in vb6.0

[rekhasc]

how to generate a graphs on query basis.....(dail y,weekly,monthl y,yearly,totall y)
i did the program on adding amounts on date basis , i want to know about how to generate a graphs on that...........
i am doing in vb6.0...(adodc1 )
and the backend is ms access......... .

[debasisdas]

Try to use the MsChart control for the purpose.

[rekhasc]

Try to use the MsChart control for the purpose.

i am using mschart.. and also i have connected the database.but the graph is not coming......... . i am using 3 fields in db date, description and amount...
i have to draw the graph against date and amount......... ...... and the graph should be automatically update......... ........could u plz help me....

[debasisdas]

Is the description field is a number type field.

[rekhasc]

Is the description field is a number type field.

date-date/time(medium date)
description-text
amount-number