Warning: A really ugly trial implementation. But I hope it helps and you can see how one can update an existing chart series. It was the first time for me to work with excel chart series.
Prerequirements:
- It exists a Sheet with name 'Sheet1'
- It exists a Chart in 'Sheet1' which has already a series
TODO:
- Extend it for your 3 series
With this (ugly) code I was able to update the series
private void buttonExcelChart_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application _excel = new _Excel.Application();
Workbook workbook = _excel.Workbooks.Open(@"c:\temp\cp.excel\ExcelChart.xlsx");
Worksheet worksheet = workbook.Worksheets["Sheet1"];
Microsoft.Office.Interop.Excel.Chart chart = worksheet.ChartObjects(1).Chart;
Microsoft.Office.Interop.Excel.Series series1= (Microsoft.Office.Interop.Excel.Series)chart.SeriesCollection(1);
Microsoft.Office.Interop.Excel.Range startX = worksheet.get_Range("A2");
Microsoft.Office.Interop.Excel.Range rangeX = worksheet.get_Range(startX, startX.End[XlDirection.xlDown]);
Microsoft.Office.Interop.Excel.Range startY = worksheet.get_Range("B2");
Microsoft.Office.Interop.Excel.Range rangeY = worksheet.get_Range(startY, startY.End[XlDirection.xlDown]);
series1.XValues = rangeX;
series1.Values = rangeY;
workbook.Save();
}
Good luck ;)