Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Thanks a ton!! completely solved the problem Regards, Deepak On Tue, Apr 23, 2013 at 7:29 PM, priti verma wrote: > Hi Deepak > Please see the attachment. > > > On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote: > >> Why not >> actually firstly i prepared a 2 dyanamic range by using offset for

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
I think other graph is not updating automatically Regards, Deepak Rawat On Tue, Apr 23, 2013 at 7:41 PM, priti verma wrote: > I hope you got your solution > > > On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote: > >> thanx for ur consideration >> >> i need to add more graphs like this with au

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Prabhu Pinky
oh i see... thanks a lot... [?] On 23 April 2013 20:00, priti verma wrote: > Hi Prabhu, > Its just depand on dyanamic range. > if you want to add more graph you have to prepare a new dyanamic rang > .and have to add these new range into legend series. > > > > On Tue, Apr 23, 2013 at 7:52 PM, Pr

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
Hi Prabhu, Its just depand on dyanamic range. if you want to add more graph you have to prepare a new dyanamic rang .and have to add these new range into legend series. On Tue, Apr 23, 2013 at 7:52 PM, Prabhu Pinky wrote: > Hi Preti, > > Really this is excellent one. this one will be very usef

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Prabhu Pinky
Hi Preti, Really this is excellent one. this one will be very useful for me very often. May i know the working procedure of this. so that i can easily do it in my workings. On 23 April 2013 19:41, priti verma wrote: > I hope you got your solution > > > On Tue, Apr 23, 2013 at 7:19 PM, Deepa

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
I hope you got your solution On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote: > thanx for ur consideration > > i need to add more graphs like this with auto update > what i need i have attached could u kindly see that > > Regards, > Deepak > > > > On Tue, Apr 23, 2013 at 7:06 PM, priti verma

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
Hi Deepak Please see the attachment. On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote: > Why not > actually firstly i prepared a 2 dyanamic range by using offset formula . > one is lable and second one is rnglabel .and then i defined the name of > that formula. after that i select the chart o

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
ok On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote: > thanx for ur consideration > > i need to add more graphs like this with auto update > what i need i have attached could u kindly see that > > Regards, > Deepak > > > > On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote: > >> Why not >> a

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
thanx for ur consideration i need to add more graphs like this with auto update what i need i have attached could u kindly see that Regards, Deepak On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote: > Why not > actually firstly i prepared a 2 dyanamic range by using offset formula . > one i

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
Why not actually firstly i prepared a 2 dyanamic range by using offset formula . one is lable and second one is rnglabel .and then i defined the name of that formula. after that i select the chart on right clicking on the chart .and go to add series and in the series name box i selected the a2 ce

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Hi Priti, If i have to add some more graphs than its not working, kindly will u share how to add more graphs with same feature example is attached regards, Deepak On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > Hi Deepak, > > Please see the attachement.Here I used Dyanamic name range by

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Abhishek Jain
Good job! On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > Hi Deepak, > > Please see the attachement.Here I used Dyanamic name range by using offset. > > Regards > priti verma > > > On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote: > >> Dear all, >> >> I have a problem regarding graph aut

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
HI how did u do this will u clarify a bit Regards, Deepak On Tue, Apr 23, 2013 at 6:33 PM, Deepak Rawat wrote: > Thanx!! > exactly what i need... > > Regards, > Deepak > > > > On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > >> Hi Deepak, >> >> Please see the attachement.Here I used Dyana

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Thanx!! exactly what i need... Regards, Deepak On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > Hi Deepak, > > Please see the attachement.Here I used Dyanamic name range by using offset. > > Regards > priti verma > > > On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote: > >> Dear all, >>

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread xlstime
Superb Priti Good job done !! . Enjoy Team XLS On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > Hi Deepak, > > Please see the attachement.Here I used Dyanamic name range by using offset. > > Regards > priti verma > > > On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread priti verma
Hi Deepak, Please see the attachement.Here I used Dyanamic name range by using offset. Regards priti verma On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote: > Dear all, > > I have a problem regarding graph auto update... > > I have to add date daily then i select data manually, is there any