title: Excel charts +C#
body: <p>I am using excel to draw charts from c#, but i need the chart to be one series related to each other not two series (when i select a range that has two columns of data)<br>
  can any one help:</p>
  
  <pre><code>        xla.Visible = true; 
          Workbook wb = xla.Workbooks.Add(XlSheetType.xlWorksheet);
          Worksheet ws = (Worksheet)xla.ActiveSheet;
  
          // Now create the chart.
          ChartObjects chartObjs = (ChartObjects)ws.ChartObjects(Type.Missing);
          ChartObject chartObj = chartObjs.Add(100, 20, 300, 300);
          Chart xlChart = chartObj.Chart;
          Range rg = ws.get_Range("B2", "C17");
          xlChart.SetSourceData(chartRange, XlRowCol.xlColumns);
  </code></pre>
  
  <p>thanks</p>