根据DataTable和TChart来构造线行图

public void TeeCharDraw()
    {
        chart = new Chart();

        CreateLines(chart, ExcelToTable().Tables[0]);

        MemoryStream tempStream = new MemoryStream();
        chart.Export.Image.JPEG.Save(tempStream);
        Response.ContentType = "Image/JPEG";
        Response.OutputStream.Write(tempStream.ToArray(), 0, (int)tempStream.Length);
        tempStream.Close();
    }   

 

public void CreateLines(Chart chart, DataTable allData)
    {
        //不用3D格式显示
        chart.Aspect.View3D = false;

        //循环所有数据的每行，每行对应创建一条线实例
        for (int i = 0; i < allData.Rows.Count; i++)
        {
            //对当前行对应创建一条线实例
            Steema.TeeChart.Styles.Line line = new Steema.TeeChart.Styles.Line();
            //为当前线创建数据源
            DataTable dt = new DataTable("lineTable");
            //添加线的X,Y轴两列
            dt.Columns.Add("X", typeof(Double));
            dt.Columns.Add("Y", typeof(Double));
            //循环列数（共21列）
            for (int j = 0; j < allData.Columns.Count; j++)
            {
                //添加线的X，Y数据。21的索引(0...21)做为X轴数据,Y值为当前行对应列的值。
                object[] rowValues = new object[2] { j, allData.Rows[i][j] };
               
                dt.Rows.Add(rowValues);
            }
            line.DataSource = dt;
            //设置线的X轴取dt的X列值。
            line.XValues.DataMember = "X";
            //设置线的Y轴取dt的Y列值。
            line.YValues.DataMember = "Y";
            //添加线到图形
            chart.Series.Add(line);
        }
    }