I'm using mscharts, but my question might not need to be chart related to be answered.


My chart contains 5 XY data points that will be shown in a spline (line graph). The X values are from text boxes 1-5, my Y values are from textboxes 6-10. I'm adding them to my chart by code.

Code:
Chart1.Series(0).Points.AddXY(Val(TextBox1.Text), Val(TextBox6.Text))
        Chart1.Series(0).Points.AddXY(Val(TextBox2.Text), Val(TextBox7.Text))
        Chart1.Series(0).Points.InsertXY(Val(TextBox3.Text), Val(TextBox8.Text))
        Chart1.Series(0).Points.AddXY(Val(TextBox4.Text), Val(TextBox9.Text))
        Chart1.Series(0).Points.AddXY(Val(TextBox5.Text), Val(TextBox10.Text))

My issue is I have to enter the data in order to make my line proper. Is there a way to first arrange the points, then add them to the chart. Otherwise if I add a lesser point in the middle, it "z's" the line...

Thanks!