C#Chart控件

            DataSet dataSet = new DataSet();
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + @"D:\test\data.xls" + ";" +
            "Extended Properties='Excel 8.0;HDR=YES;IMEX=2';";
            conn.Open();
            string ss = "select* from[Student$] ";
            OleDbCommand oleDb = new OleDbCommand(ss, conn);
            OleDbDataReader dbDataReader = oleDb.ExecuteReader();
            this.chart1.Series["Series1"].Points.DataBindXY(dbDataReader, "name", dbDataReader, "age");

            this.chart1.Titles.Add("学生年龄分布");//标题
            this.chart1.ChartAreas[0].Axes[0].MajorGrid.Enabled = true;//X轴上网格
            this.chart1.ChartAreas[0].Axes[1].MajorGrid.Enabled = false;//Y轴上网格
            this.chart1.ChartAreas[0].Axes[0].MajorGrid.LineDashStyle=ChartDashStyle.Dash;   //网格类型 短横线
            this.chart1.ChartAreas[0].Axes[0].MajorGrid.LineColor = Color.Red;
            this.chart1.ChartAreas[0].Axes[0].MajorTickMark.Enabled = false;                //  x轴上突出的小点
            this.chart1.ChartAreas[0].Axes[1].LabelStyle.Format = "#岁";
            this.chart1.ChartAreas[0].Axes[0].LineWidth = 3;

            this.chart1.Series["Series1"].ToolTip = "#VALX年\r#VAL";//鼠标提示
            this.chart1.Series["Series1"].ChartType = SeriesChartType.Line;

            this.chart1.Series["Series1"].Color = Color.Red;               //线条颜色
            this.chart1.Series["Series1"].BorderWidth = 3;                 //线条粗细
            this.chart1.Series["Series1"].MarkerBorderColor = Color.Red;   //标记点边框颜色
            this.chart1.Series["Series1"].MarkerBorderWidth = 3;             //标记点边框大小
            this.chart1.Series["Series1"].MarkerColor = Color.Red;       //标记点中心颜色
            this.chart1.Series["Series1"].MarkerSize = 5;                 //标记点大小
            this.chart1.Series["Series1"].MarkerStyle = MarkerStyle.Circle;  //标记点类型
            conn.Close();