$$Excel-Macros$$ Graph Query

2014-06-11 Thread Shrinivas Shevde
Dear all Can I have multiple axis in a graph (more than 2) I want to have a graph having values ranging ( .1 to 1.2,65 to 75, 150 to 168) Thanks in advance -- Shrini -- 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 Facebook page

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

$$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Dear all, I have a problem regarding graph auto update... I have to add date daily then i select data manually, is there any idea that i add date and the graph update automatically? Sample is attached. regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Re: $$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
ma* > > *+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 > *Subject:* $$Excel-Macros$$ Graph > > ** ** &

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
Subject: $$Excel-Macros$$ Graph 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 already BANNED for violation) 1) Use concise, accurate thread titles

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

$$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
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 already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

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

$$Excel-Macros$$ Graph with radio button

2012-06-04 Thread santosh subudhi
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. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use c

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

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

$$Excel-Macros$$ Graph Query

2012-05-31 Thread Karan Singh
Dear All, I want to create a graph as shown below. Is there any way to to create chart like this. I tried my best to search and create this but I couldn't. Please help me to create this graph. Thanks Karan Singh www.KagGran.com -- FORUM RULES (986+ members already BANNED for violation) 1) Us

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

2012-05-09 Thread Deba Ranjan
.@gmail.com > > *From:* Deba Ranjan > *Sent:* Wednesday, May 09, 2012 7:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Graph formatting condition > > *Hi expert, > > >I have a query, Please find the attachment and help me out this > conc

$$Excel-Macros$$ Graph Query (Its very urgent)

2011-01-17 Thread Shrinivas Shevde
Dear all I have a problem in Excel Graph . Please find attached Sheet and help me Please lok at the graph ( I want to chenage the Legend and C should be on top then D then B then A) Can any one help me to do this Thanks in advance Waiting for reply -- Shrini -- --

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

$$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
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 months by the top 10 customers , whats the best way? I am not good in graphs and i need to present this to the chief . Please help me Thanks Best re

$$Excel-Macros$$ graph to shape ?

2010-07-05 Thread Alfred WALLACE
Hi to all ! I'm wondering if it is possible to set à graph to a shape in vba ? Thx for your help -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exc

$$Excel-Macros$$ Graph as per parato,,, ascending order

2010-04-15 Thread sagaraher
Hi frds.. I need help for plotting graph.. I ve a data for quality issuesi ve 10 diff. clients & ther freuency...I need to plot graph in ascending order by default in every month. e.g. Sr. No. ClientFrq. 1X 10 2Y