Re: $$Excel-Macros$$ Graph Query

2014-05-10 Thread Shrinivas Shevde
thanks problem solved On Sat, May 10, 2014 at 12:34 AM, ashish koul wrote: > wht do u wanna do .. its x y scatter chart > > > On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde > wrote: > >> Dear All >> I received one excel file in whih there is a graph. >> When I try to edit series it shows X a

Re: $$Excel-Macros$$ Graph Query

2014-05-09 Thread ashish koul
wht do u wanna do .. its x y scatter chart On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde wrote: > Dear All > I received one excel file in whih there is a graph. > When I try to edit series it shows X and Y series in same legend (screen > shot attached) > Please let me know how to do the same.

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

Re: $$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
*Hi, Please help in preparing the graph on the attached data * On Tue, Jun 5, 2012 at 6:33 PM, Rajan_Verma wrote: > Hi Smith > > Every Chart needs related data, can you provide the data of *Growth*? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** *

Re: $$Excel-Macros$$ Graph with radio button

2012-06-05 Thread pawel lupinski
thanks Raj, I've just noticed, it's still too complicated to me but with the time maybe. Thanks Pawel From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Tuesday, June 5, 2012 1:49 PM Subject: RE: $$Excel-Macros$$ Graph with radio butt

RE: $$Excel-Macros$$ Graph

2012-06-05 Thread Rajan_Verma
Hi Smith Every Chart needs related data, can you provide the data of Growth? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Smitha S R Sent: 05 June 2012 3:25 To: excel-macros@googlegroups.com Subje

RE: $$Excel-Macros$$ Graph with radio button

2012-06-05 Thread Rajan_Verma
05 June 2012 3:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Graph with radio button Hi Rajan, is there any chance, that you can explain me how you've done it? Regards, Pawel _ From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Monday, Ju

Re: $$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
Please help on the graph preparation On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R wrote: > Hi, > > Please help me in drawing the graph, as per the attachment. > Need a graph , month wise where the employee growth, cost wise growth and > team could be identified . > > -- > FORUM RULES (986+ members

Re: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread pawel lupinski
Hi Rajan, is there any chance, that you can explain me how you've done it? Regards, Pawel From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Monday, June 4, 2012 2:11 PM Subject: RE: $$Excel-Macros$$ Graph with radio button HTH     Regards

RE: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread Rajan_Verma
HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Gawli Sent: 04 June 2012 2:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Graph with radio button See the attached

Re: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread Maries
s . >> >> Hope I am clear with query. >> >> Regards >> Santosh >> santoshkumar.subu...@gmail.com >> >> From: talk2mar...@gmail.com >> Date: Mon, 4 Jun 2012 02:01:14 -0700 >> Subject: Re: $$Excel-Macros$$ Graph with radio button >> To:

Re: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread Anil Gawli
ll select "team 1" then the graph should show only the > data for the three people and no zero's . > > Hope I am clear with query. > > Regards > Santosh > santoshkumar.subu...@gmail.com > > From: talk2mar...@gmail.com > Date: Mon, 4 Jun 2012 02:01:14 -

RE: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread santosh subudhi
bu...@gmail.com From: talk2mar...@gmail.com Date: Mon, 4 Jun 2012 02:01:14 -0700 Subject: Re: $$Excel-Macros$$ Graph with radio button To: excel-macros@googlegroups.com Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: Hi Group, I want to

Re: $$Excel-Macros$$ Graph with radio button

2012-06-04 Thread Maries
Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > I want to create a graph which will show the work performance of different > teams as and when they are selected. > > Attached is the sample sheet for your easy reference. > -- > R

RE: $$Excel-Macros$$ Graph Query

2012-06-03 Thread Rajan_Verma
See if it helps Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Karan Singh Sent: 01 June 2012 11:04 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Graph Query Dear All, I want to

Re: $$Excel-Macros$$ Graph Query

2012-06-01 Thread David Grugeon
Try a stacked bar chart. Excel will put it as 3 separate bars and you have to go into the data setting and tell it to swap x and y. You might try a percentage graph variant. Ten you need a second series to give the cursor with values like h 45, 2, 53 to show the cursor. Then you tweak the fo

Re: $$Excel-Macros$$ Graph formatting condition

2012-05-09 Thread Deba Ranjan
*Thank you so much *Don Guillett. very thanks. Thanks & Regards,* * *Deba Ranjan P*** On Wed, May 9, 2012 at 7:41 PM, dguillett1 wrote: > Modified graph . You can make other changes to graph > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deb

Re: $$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
hello, Can any one help me on this? Best regards Rajesh On Sun, Jul 11, 2010 at 6:08 PM, Rajesh Janardanan wrote: > Hi, > > Please find attached the sample file, thanks for the help. > > Best regards > Rajesh > > On Sun, Jul 11, 2010 at 4:42 PM, Vinod N wrote: > >> Please send a sample data

Re: $$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
Hi, Please find attached the sample file, thanks for the help. Best regards Rajesh On Sun, Jul 11, 2010 at 4:42 PM, Vinod N wrote: > Please send a sample data file.. It'll help for quick reply of your > query... > > > On Sun, Jul 11, 2010 at 6:21 PM, Rajesh Janardanan wrote: > >> Hi All, >> I

Re: $$Excel-Macros$$ Graph - Question

2010-07-11 Thread Vinod N
Please send a sample data file.. It'll help for quick reply of your query... On Sun, Jul 11, 2010 at 6:21 PM, Rajesh Janardanan wrote: > Hi All, > I need to present a graph , I have the data to be analysed for top 10 > customers , over the last 12 months , that is the quantity sold over 6 > month