DataGrid MSChart Question 2

[DK47]

I am trying to create an MSChart for my user that will grow with each new record. Also I would like to create the ability for the user to scroll from beginning of the chart to the end. The record count(dates and values) could grow to significant numbers, possibly several hundred.
My sense is that using an ado connection bound with a DataGrid could be used, but thus far, after many hours of headknocking failures, I decided to ask for help.

Three questions:
1. Can what I need be done?

2. Where could I get some sample code that would set me on the correct path?

3. Will the MSChart require an array if data is taken from the DataGrid?

Thanks in advance,
Dwight

 

[DrJavaJoe]

Place the mschart control on a picture box and then add a HScroll, then in the HScroll change event change the mschart left property. This is just a thought haven't played with the idea.

 

[migueleitor]

hey go to

http://www.freevbcode.com

and type MSCHART. Here it's a example

Dim arrData(2, 1 To 3)
arrData(0, 1) = "Ene" ' Establece las etiquetas en la primera serie.
arrData(1, 1) = "Feb"
arrData(2, 1) = "Mar"
Me.MSChart1.ChartType = VtChChartType2dXY

arrData(0, 2) = -2
arrData(1, 2) = 4
arrData(2, 2) = -0.3

arrData(0, 3) = -2
arrData(1, 3) = 3
arrData(2, 3) = 6.3
MSChart1.ChartData = arrData

i hope it will work a little