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

2015-03-10 Thread amar takale
Dear Paul, Thanks very much & I got my mistek (about sheet name give to range) after analyse. Regards Amar On Mon, Mar 9, 2015 at 5:01 PM, Soumyendu Paul wrote: > Dear Amar, >Kindly find the attachment ,analyse it and complete rest. > > > > > On Sat, Mar 7, 2015 at 11:48 AM, am

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

2015-03-06 Thread amar takale
Dear Paul Superb idea for simple formula.but i do same as per use offset formula but chart not change as per date range,why? Pls some guide me On Fri, Mar 6, 2015 at 7:06 PM, Maciej Piotrowicz wrote: > WOW. It is illogical but works. I have not known this option. Is it normal > function of Excel

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

2015-03-06 Thread Maciej Piotrowicz
WOW. It is illogical but works. I have not known this option. Is it normal function of Excel that chart knows range without even mentioning ranges I3:L3? Deleting them causes mistakes in chart. Thx for this:) W dniu czwartek, 5 marca 2015 02:25:53 UTC+1 użytkownik Soumyendu Paul napisał: > > D

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

2015-03-04 Thread Soumyendu Paul
Dear Amar, Sorry for being late. Kindly find the attachment. On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote: > Dear experts > > I want to update chart as per date change in cell I3 & J3.means between > date range. i think it done by offset formula through name range. > > pls guide me > >

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

2015-02-24 Thread amar takale
Can any body help me On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote: > Dear experts > > I want to update chart as per date change in cell I3 & J3.means between > date range. i think it done by offset formula through name range. > > pls guide me > > Regards > Amar > > -- > Are you =EXP(E:RT)

$$Excel-Macros$$ Dynamic chart between data range

2015-02-22 Thread amar takale
Dear experts I want to update chart as per date change in cell I3 & J3.means between date range. i think it done by offset formula through name range. pls guide me Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Fac