R1C1 reference style

I have a chart in my worksheet.

I populate the chart using code below, because i may have 2 or more columns, it changes, I would like to use column and cell numbers (R1C1 reference style) not column letters.

works...

chart.NSeries.Add("B5:I5", false);

chart.NSeries.CategoryData = "B4:I4";

i try following but does not work.....

chart.NSeries.Add("R[5]C[2]:R[5]C[9]", true);

Hi,

Thanks for considering Aspose.Cells.

Now chart.NSeries.Add method doeas not support R1C1 style.We will look into this feature.

can you suggest a work around ?

Hi,

Please try this fix.

Please use NSeries.AddR1C1(string area,bool isVertical) method.