Need help--vb.net integrating data grid view and charts

Apologies. I've cleaned up the code to now look like the one below. For the project I am suppose to have a datagridview, and two charts with a button in the first window. Then you click a button to add a sample (group of five with five different text boxes, tbUno.Text, etc) in the other windows forum called Values. I then click another button to enter the data I just put in the Values window forum into the VariableControl forum in the datagridview. They are entered in as five different columns. The two charts are XBar charts and Range charts. I already have it coded so that the average of the five entries I just made automatically makes a point in the XBar chart (of those values average) and in the Range chart (of those values range). In the datagrid view you can enter unlimited amount of data. Now I need to find the average of all of the averages entered in the datagridview that are plotted on the XBar chart, and I need to input them on that same chart for the center line. I also need to find the average of all of the ranges plotted in the Range chart and then plot that average in the range chart for the center line as well. In addition, I need to be able to use those values of the average of the averages and the average of the ranges in order to solve for different equations. I think I need to declare two addition arrays as class members but I wasn't sure if I was doing right or how to really.


Public Class VariableControl
Dim array_of_all_values As Object
Dim NumCol, NumRow As Integer

Private Sub btnAdd_Click(sender As Object, e As EventArgs) Handles btnAdd.Click
Try
If Values.ShowDialog = Windows.Forms.DialogResult.OK Then
Dim MyArray(4) As Double

MyArray(0) = Values.tbUno.Text
MyArray(1) = Values.tbDos.Text
MyArray(2) = Values.tbTres.Text
MyArray(3) = Values.tbCuatro.Text
MyArray(4) = Values.tbCinco.Text

dgvValues.Rows.Add(MyArray(0), MyArray(1), MyArray(2), MyArray(3), MyArray(4))

chXBar.Series(0).Points.Add(MyArray.Average)

chRange.Series(0).Points.Add(MyArray.Max - MyArray.Min)
'Series(1) for each of the charts will be the center line, I then also need the upper control limit and lower control limit which I cannot plot until I have the center line values of each of the charts.


chXBar.ChartAreas(0).AxisY.IsStartedFromZero = False
chRange.ChartAreas(0).AxisY.IsStartedFromZero = False
End If
Catch ex As Exception
MsgBox("Please enter in numeric values.")
End Try
End Sub


End Class

You got most of it right. I'm trying to find the average of all of the averages in the first chart (xBar), and then the average of all of the ranges in the second chart (Range). I know how to do the max and min. I'm just not sure how to construct the code to copy each array I entered into the textboxes into another array....

I wanted to take all of the averages from the first chart--and copy them into an array member class (Dim XBarVal As Double={}) and then I wanted to take all of the ranges from the second chart and copy them into a separate array member class (Dim RangeVal As Double={}).

I need an example, I'm just not sure how to get the syntax to copy the data points into another array correctly.