I have couple of databases. What I need to do is following:
I make a query to database and get all the info I need with a particular date. The "connection" I make with AdoDc. I get the result in DataGrid like this:

Pvm$ = InputBox$("Anna haettava päivämäärä, esim. 12.3.2002", "Päivämäärä")
MiniSondeGrid_form.MiniSonde_ado.RecordSource = "SELECT * FROM MiniSonde_data WHERE Päivämäärä = " & "'" & Pvm$ & "'"
MiniSondeGrid_form.MiniSonde_ado.Refresh
MiniSondeGrid_form.DataGrid1.Caption = Pvm$ + " tiedot"
MiniSondeGrid_form.Show

How I then draw a chart from that DataGrid with MSChart? I have understanded that it is easier to use MSChart if you make the connection with dataEn? But how I make same kind of query (or mainly pass the 'parameter'(Date)) to dataEn?
So mainly how do I draw a chart from DataGrid in a away or another? Thanks!