The issue is that when you are reading the data from the csv it is adding all the data as string and the chart is then reading the values as string thats why none of the Chart1.ChartAreas(0).AxisX.Maximum = 10 changes the axis.
The column type have to be changed so
private void button2_Click(object sender, EventArgs e)
{
DataTable dtCloned = csvData.Clone();
dtCloned.Columns["Delta_Sigma"].DataType = typeof(double);
dtCloned.Columns["CpK_Refrence"].DataType = typeof(double);
foreach (DataRow row in csvData.Rows)
{
dtCloned.ImportRow(row);
}
chart1.DataSource = dtCloned;
chart1.ChartAreas[0].AxisX.Minimum = 0;
chart1.ChartAreas[0].AxisX.Maximum = 10;
chart1.ChartAreas[0].AxisX.Minimum = -5;
chart1.ChartAreas[0].AxisX.Maximum = 5;
chart1.Series["Series2"].YValueMembers = "Delta_Sigma";
chart1.Series["Series2"].XValueMember = "CpK_Refrence";
chart1.DataBind();
}