exc.Charts.Add(Missing,Missing,1,Missing); 
    exc.ActiveChart.ChartType=Excel.XlChartType.xlColumnClustered;
    exc.ActiveChart.SetSourceData(worksheet.get_Range("A1","B10"),Excel.XlRowCol.xlColumns);
    exc.ActiveChart.Location(Excel.XlChartLocation.xlLocationAsObject,"sheet1");
    exc.ActiveChart.HasTitle=true;
    exc.ActiveChart.ChartTitle.Text="图表名称";
    exc.ActiveChart.HasDataTable=false;