title: How to generate a chart from an Excel sheet?
body: <p>I can generate an Excel file when I pass a <code>datatable</code> into the below function:</p>
  
  <pre><code>public static void ExportDataTableToExcel(DataTable dt, string filepath)
  {
      object missing = Type.Missing;
  
      object misValue = System.Reflection.Missing.Value;
  
      //create excel
      Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
  
      //add excel workbook
      Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Add();
  
      //add worksheet to workbook
      Microsoft.Office.Interop.Excel.Worksheet ws = wb.Sheets[1] as Microsoft.Office.Interop.Excel.Worksheet;
  
      //add 2nd worksheet to workbook
      Microsoft.Office.Interop.Excel.Worksheet ws2 = wb.Sheets[2] as Microsoft.Office.Interop.Excel.Worksheet;
  
      //Set the header-row bold
      ws.Range["A1", "A1"].EntireRow.Font.Bold = true;
  
      //Adjust all columns
      ws.Columns.AutoFit();
  
     //spit top row
      ws.Application.ActiveWindow.SplitRow = 1;
  
      //insert image into worsheet 2
      ws2.Shapes.AddPicture("C:\\Koala.JPG", Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 50, 50, 300, 300); 
  
      //freeze top row
      ws.Application.ActiveWindow.FreezePanes = true;
  
  
      int rowCount = 1;
  
      foreach (DataRow dr in dt.Rows)
      {
          rowCount += 1;
  
          for (int i = 1; i &lt; dt.Columns.Count + 1; i++)
          {
              // Add the header the first time through
  
              if (rowCount == 2)
              {
                  ws.Cells[1, i] = dt.Columns[i - 1].ColumnName;
                  ws.Cells[1, i].Interior.ColorIndex = 40;
  
                  // add cell border
                  ws.Cells[1, i].Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
              }
  
              ws.Cells[rowCount, i] = dr[i - 1].ToString();
  
              // add cell border
              ws.Cells[rowCount, i].Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
          }
      }
  
      Microsoft.Office.Interop.Excel.Range range = (Microsoft.Office.Interop.Excel.Range)ws.UsedRange;
  
      Console.Write(range.ToString());
  
      wb.SaveAs(@"C:\Test.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue,
                                           misValue, misValue, misValue,
                                           Excel.XlSaveAsAccessMode.xlExclusive, misValue,
                                           misValue, misValue, misValue, misValue);
  
      wb.Close(missing, missing, missing);
  
      excel.Quit();
  }
  </code></pre>
  
  <p>This function works well. I need to add a graph from C# code to this Excel file. I tried a few methods, but did not find proper way to implement.</p>