Posted 8 September 2017, 2:34 pm EST
I have no problem charting a range of cells in a Spread control if I specify the range using A1 notation but I can not get it to work with R1C1 notation.
Since my app generates data on the fly (from database tables) my spreadsheets always use R1C1 references, since I have no idea what is in which column - or even how many columns there will be.
Is there a way to specify that I want to use R1C1 notation in the Chart.SeriesDataField() function?
Chart.SeriesDataField(Spread, "Col2", "Sheet1!R1C2:R5C2")
Chart.SeriesDataField(Spread, "ColB", "Sheet1!$B$1:$B$5")
If not, is there a function available to convert integers to their corresponding Letter strings?