Very excellent Example Don Sir........... Masterpiece......................
On Sat, Oct 15, 2011 at 7:44 PM, dguillett1 <dguille...@gmail.com> wrote: > If you just need it to be dynamic withOUT having to select the month, > change my cola formula to this so when each month is added it will chart > colA > =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 <dguille...@gmail.com> > *Sent:* 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 <noorain.ans...@gmail.com> > *Sent:* Friday, October 14, 2011 9:49 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Dynamic chart range > > Dear Atul, > > Please see attached sheet with Dynamic Chart example. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > On Thu, Oct 13, 2011 at 5:32 AM, Atul <atul_pate...@yahoo.com> wrote: > >> 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 >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel