![]() |
Select different columns within a range
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 getting 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. |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com