Question

I want to edit the name of the legends given on my excel chart. Right now I have 5 Series on a chart and the legend displays the names "Series 1", "Series 2", "Series 3", "Series 4", "Series 5". I need to change them to "DS1", "DS2" etc. I am using Microsoft.Office.Interop.Excel for my program. Can someone please help me out? thanks in advance!

Answer 1

Using SpreadsheetGear for .NET you would do it like this:

        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(@"C:Chart.xlsx");
        SpreadsheetGear.Charts.IChart chart = workbook.Worksheets["Sheet1"].Shapes["Chart 1"].Chart;
        chart.SeriesCollection[0].Name = "My Series Name";
        workbook.Save();

Since the SpreadsheetGear API is similar to the Excel API, you should be able to figure out how to do it in Excel from this SpreadsheetGear code. Note that SpreadsheetGear does use zero based indexes, so chart.SeriesCollection[0] in SpreadsheetGear would be chart.SeriesCollection[1] in Excel (or maybe chart.SeriesCollection.Item(1) since indexers don t always work as expected when using Excel via COM Interop).

Answer 2

For that you need to change the range as from start. e.g. you can set the range from A1 to C3 i.e. where your column name starts As your excel sheet having A column with "DS1", "DS2" etc.

友情链接