如何使用 C# 将其他系列添加到 Excel 图表

I am trying to add an additional data series to the chart this shows CPU threshold, I can get the range and create the graph with out the threshold on it, but I don't know how to add the threshold value to the chart. do I need to create another chart object? can I use the existing and just add teh new range in?

您如何创建图表？ -- 请参阅下面的代码。 此图表是否已在 Excel 文件中创建，并且您想要修改 Excel 文件中的图表？是的，图表已经在 Excel 文件中。

Excel.ChartObjects sCPUChart； Excel.ChartObject sCPUChartObjects；

        sCPUChart = sDBSheet.ChartObjects(Type.Missing);
        sCPUChartObjects = sCPUChart.Add(49, 15, 360, 215);

        Excel.Chart sChartCPU;

        sChartCPU = sCPUChartObjects.Chart;
        sChartCPU.SetSourceData(cpuChartRange, Missing.Value);
        sChartCPU.ChartWizard(Source: cpuChartRange, Gallery: Excel.XlChartType.xlLine, Format: 2, HasLegend: true);
        sChartCPU.Location(Excel.XlChartLocation.xlLocationAsObject, sDBSheet.Name);

        //CPU Chart Axis
        Excel.Axis xSChartCPUAxis;
        xSChartCPUAxis = sChartCPU.Axes(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary);


        Excel.Axis ySChartCPUAxis;
        ySChartCPUAxis = syChartCPU.Axes(Excel.XlAxisType.xlValue, Excel.XlAxisGroup.xlPrimary);
        ySChartCPUAxis.HasMajorGridlines = true;
        ySChartCPUAxis.MaximumScaleIsAuto = true;

        //Set Summary CPU Series
        Excel.Series sCPUSeries = sChartCPU.SeriesCollection(1);
        sCPUSeries.Name = "CPU";


//-------
// this is where I am having my issue
//I don't know how to add the threshold line to the graph with the existing graph being displayed

        //sChartCPU.set_HasAxis(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlSecondary, true);
        //summaryChartCPU.SetSourceData(summaryMemThreshold, Type.Missing); -- things break
        //-------
I have now done the following:


   Excel.SeriesCollection threshold = sChartCPU.sseriesCollection();
   Excel.Series line = threshold.NewSeries();
   line.Formula = "=SERIES(Summ!$D$54,Summ!$C$55:$C$56,Summ!$D$55:$D$56)";
   line.ChartType = Excel.XlChartType.xLScatterLinesNoMarkers;


when the threshold line is created I have the following

我在单元格 D54 中拥有的值 - 阈值

  C55 = 0
  C56 = 1
  D55 = 75
  D56 = 75

我不知道如何删除图表中出现的 2 个附加轴 如果我注释掉 line.ChartType，那么轴是正确的，但我只得到一个阈值数据点？我不明白为什么。

var series = (SeriesCollection) yourChart.SeriesCollection();
var line = series.NewSeries();

line.Name = "CPU Threshhold";
//line.Values = ...;
//line.XValues = ...;

//formatting