How to handle Axis Labels and Tool Tip with Null values in MS Chart Control

See more:

SQL-Server-2005

ASP.NET

, +

Hi,

I'm drawing Line Graph from the back end table values. The dataset contains Empty(Null) values too. So how to draw the graph by properly adding Tooltips and Axis Labels. Here I get Error in showing Tool Tips and Axis Labels when Null values plotting.

for (int i = 0; i < dataset1.Tables[0].Rows.Count; i++)
                {
                    if (dataset1.Tables[0].Rows[i]["Val"].ToString() == "")
                    {

                        //chart1 .Series["series1"].Points.AddY(0);
                        
                        chart1.Series["series1"].EmptyPointStyle.BorderWidth = 1;
                        chart1 .Series["series1"].EmptyPointStyle.BorderColor = Color.Red;
                        chart1 .Series["series1"].EmptyPointStyle.MarkerColor = Color.Red;
                        chart1 .Series["series1"].EmptyPointStyle.MarkerSize = 15;
                        chart1 .Series["series1"].EmptyPointStyle.MarkerColor = Color.FromArgb(64, 64, 64);
                        chart1 .Series["series1"].EmptyPointStyle.BorderWidth = 1;
                        chart1 .Series["series1"].EmptyPointStyle.MarkerColor = Color.FromArgb(0, 192, 0);
                        chart1 .Series["series1"].EmptyPointStyle.CustomProperties = "EmptyPointValue = Average";
                      
                    }
                    else
                    {
                        chart1 .Series["series1"].Points.AddY(Convert.ToInt32(dataset1.Tables[0].Rows[i]["Val"]));
                        chart1 .Series["series1"].Points[i].AxisLabel = dataset1.Tables[0].Rows[i]["dys_Month"].ToString();
                        chart1 .Series["series1"].Points[i].ToolTip = dataset1.Tables[0].Rows[i]["Val"].ToString();
                    }
                }
}

Thanks in advance