PDA

View Full Version : EXCEL VBA DOUBT



ramadk
01-10-2008, 05:46 AM
Hi all,

I have data in excel sheet each column represents one variable data is aviable from row 2 to row 15 and row 1 represents the variable name.
Now I need to draw histogram for data in each column. I tried this but I am uable to change the range dynamically.

Could any one resloves this issue I am greatful to them

Thanks and regards
Rama Kishroe D

Bob Phillips
01-10-2008, 06:58 AM
Use dynamic named ranges like



=OFFSET($A$1,0,0,1,COUNTA($1:$1))


which would cover row 1, the headings, alone, and use these in the chart source data.