Selecting two different columns in excel using VSTO

[Kiran]

I am using VSTO 2005 SE to create a radar chart in excel workbook. the data
is present in a worksheet in the format


HighBrand Application 1 Application 2
3 -1 -1
3.3 -1.1 -1.1
3.3 -1.1 -1.1
3.3 -1.1 -1.1
2.7 -0.9 -0.9
3.45 -1.15 -1.15
2.4 -0.8 -0.8
3 -1 -1
3.45 -1.15 -1.15
2.7 -0.9 -0.9
2.7 -0.9 -0.9
0 0



I am trying to create one radar chart for each application along with the
highbrand values, so if there are 5 applications, there should be 5 charts
created and each chart plotting highbrand value with the application value in
it.

Chart 1 should be generated using Highbrand values and Application1 Values

Chart 2 should be generated using Highbrand values and Application2 Values

and so on....


I am facing a problem in selecting highbrand column and application column
when they are not adjacent.
Chart 1 is coming fine, but to generate chart2 this formula doesnt work.
The formula works fine when written in this format :

Excel.Range selectionRange = technologyWorkSheet.get_Range("='Technology
Evaluation Sheet'!$C$32:$C$44,'Technology Evaluation Sheet'!$E$32:$E$44",
Type.Missing);

but it doesnt work when written in R1C1 format. like:

Excel.Range selectionRange1 = technologyWorkSheet.get_Range("='Technology
Evaluation Sheet'!R32C3:'Technology Evaluation Sheet'!R44C3,'Technology
Evaluation Sheet'!R32C5:'Technology Evaluation Sheet'!R44C5", Type.Missing);


The no. of applications is dynamic, so need to have variable in place of
rows and columns in the formula. Please help me out.