two series in one graph excel using c#

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • naish
    New Member
    • Nov 2007
    • 5

    two series in one graph excel using c#

    Hi,
    My code drawing a graph in excel sheet. There one colum for lower pressure and another one for upper pressure. Any howi can draw a series for one pressure but i am not able to draw two series one for lower and nother for upper in a single graph.
    My code is here
    Before this code i opened worksheet , imported the csv data and trying to plot it on the graph.

    Excel.ChartObje cts chartObjs = (Excel.ChartObj ects)excelWorks heet.ChartObjec ts(Type.Missing );
    //Range drawing graph for b2 to b100 cells from stylesheet
    range = excelWorksheet. get_Range("B2", "B100");
    // position of the chart
    Excel.ChartObje ct chartObj = chartObjs.Add(2 00, 20, 300, 300);
    Excel.Chart xlChart = chartObj.Chart;

    xlChart.ChartTy pe = Excel.XlChartTy pe.xlXYScatterS moothNoMarkers;
    // ploting graph for the range and setting it
    xlChart.SetSour ceData(range, Type.Missing);

    Colum B has lower pressure and colum c has upper pressure. i Want to draw both pressure graph in a one chart.
    Any doughts if i cant explain it then ask me
    Thks a lot,
    Naish
Working...