I created a ChartType.Bar100PercentStacked with one category x label and several series eg.. nSeries.Add("Q10!A1", false) ; etc... all is well the graph is created.
I then attempt to create another graph with two category x labels and several series eg nSeries.Add("Q10!A5,Q10!A7 ", false) ; note i dont want A5 to A7, I want A5 and A7, A6 has other information.
Software compiles and runs with no errors and the Excel spreadsheet is created, however, when opening the file, Excel spits the dummy with a read file error, it opens after i OK the message, then Excel displays a series of more errors eg there is damage to the file etc... Excel finaly opens, the data is there but no graphs.
The problem lies within how i add the series nSeries.Add("Q10!A5,Q10!A7 ", false) ;
What is the correct syntax to reference multiple cells not in consecutive order?