Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread dguillett1
Thanks Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Saturday, October 15, 2011 12:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dynamic chart range Very excellent Example Don Sir... Masterpiece.. On Sat

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread NOORAIN ANSARI
> =OFFSET(SAS!$A$3,0,0,COUNTA(SAS!$A:$A)-1,1) > colB > =offset(colA,0,1) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* dguillett1 > *Sent:* Saturday, October 15, 2011 8:09 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$E

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread dguillett1
: Saturday, October 15, 2011 8:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dynamic chart range With dynamic name applied. See SAS sheet Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Friday, October 14, 2011 9:49 PM To: excel-macros

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread ashish koul
http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html On Sat, Oct 15, 2011 at 8:19 AM, NOORAIN ANSARI wrote: > Dear Atul, > > Please see attached sheet with Dynamic Chart example. > > -- > Thanks & regards, > Noorain Ansari > *

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-14 Thread NOORAIN ANSARI
Dear Atul, Please see attached sheet with Dynamic Chart example. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 13, 2011 at 5:32 AM, Atul wr

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-12 Thread Sam Mathai Chacko
Another faster method would be =Sheet1!$A$1:INDEX(Sheet1!$A$1:$A$1000,COUNTA(Sheet1!$A$1:$A$1000)) OR for a more expanded range =Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A)) Regards, Sam Mathai Chacko (GL) On Thu, Oct 13, 2011 at 8:17 AM, rajan verma wrote: > You can use Offset Func

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-12 Thread rajan verma
You can use Offset Function to Create Dynamic Name Range and can use this Range as Chart Data Source =offset($A$2,,,Counta($A:$A),counta(ROw(2)) Create a New Name Range and put this Function there .. On Thu, Oct 13, 2011 at 5:32 AM, Atul wrote: > Hi All, > I want to make chart range dynamic

$$Excel-Macros$$ Dynamic chart range

2011-10-12 Thread Atul
Hi All, I want to make chart range dynamic For example, range A1:g1 represents series for the first week and I want to extend the range for the second week means I want to change the range to A1:N1. Please help me to make it dynamic Thanks Atul -- ---