Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 65
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I select a range? Dan Excel Worksheet Functions 2 February 1st 09 08:49 PM
How can change range to select active rows instead of :=Range("S10 ldiaz Excel Discussion (Misc queries) 7 August 29th 08 03:52 PM
I can't select a range in VBA bigjim Excel Discussion (Misc queries) 4 April 12th 08 12:43 AM
When entering data into a range of cells, select the entire range. Q Excel Discussion (Misc queries) 0 September 26th 07 04:36 AM
Select updated data from a range of columns Alylia Excel Worksheet Functions 5 August 30th 05 01:53 PM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"