Non-adiacent cells problems on chart NSeries


I'm using an Excel template which contains charts. I cannot set Values of a NSeries Item or CategoryData for non adjacent cells:

Dim wSheet as Worksheet

Dim wChart as Chart = wSheet.Charts(0)

wChart.NSeries.Item(0) = "E6,E10"


wChart.CategoryData = "D6,D10"

Cells "E" and "G" contain integer values ; cells "D" contain string values. Excel cannot open the new created report( kind of error message). Can anyone help me to solve that problem ?

Cristian Lapadat


Which version do you use.

Please try the attached verion.