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)

Re: $$Excel-Macros$$ Dynamic Chart

2013-09-13 Thread Chandra Shekar
Hello Ashish, I got the solution for this and also attached formulas if somebody can use it. Let me know is there any steps for doing it Thank you very much. Regards, Chandra On Thu, Sep 12, 2013 at 7:06 PM, ashish koul wrote: > click on the series you will see the formula like below > > =S

Re: $$Excel-Macros$$ Dynamic Chart

2013-09-12 Thread ashish koul
click on the series you will see the formula like below =SERIES(,Sheet2!$E$3:$N$3,Sheet2!$E$16:$N$16,3) now replace all starting from $ with name range =SERIES(,Sheet2!namerange1,Sheet2!namerange2,3) see if it works On Wed, Sep 11, 2013 at 7:10 PM, Chandra Shekar < chandrashekarb@gmail.

Re: $$Excel-Macros$$ Dynamic Chart - Reg

2013-02-15 Thread amar takale
Thanks Sekar,I will wait for your reply On Sat, Feb 16, 2013 at 8:40 AM, RAJA SEKAR wrote: > Dear Amit, > > for min and Max for Entire Range use > > > MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn > Min (R_S2) & MAX(R_S2) @ Relative Performance Column > > let me to work out on rest > > > On 15 Fe

Re: $$Excel-Macros$$ Dynamic Chart - Reg

2013-02-15 Thread RAJA SEKAR
Dear Amit, for min and Max for Entire Range use MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn Min (R_S2) & MAX(R_S2) @ Relative Performance Column let me to work out on rest On 15 February 2013 14:17, amar takale wrote: > Dear Sekar, > > Great! > Thanks a lot,extact which work I want through

Re: $$Excel-Macros$$ Dynamic Chart - Reg

2013-02-14 Thread RAJA SEKAR
Dear Amar, In this file we have applied logic of "Min" as indicator to fix the range, i.e., "Min" is located in F 57 in attached file and range is arrived 57 -2 (55th) row. you can use *CountA($A:$A)-1* instead of *MATCH("MIN",ABB!$F:$F)-2* On 15 February 2013 11:11, amar takale wrote: > T

Re: $$Excel-Macros$$ Dynamic Chart - Reg

2013-02-14 Thread amar takale
Hi Sekar, Thank y very much this kind of solution,but still I confused why space between two rows, if do that then in line chart show little gap to touch axis.I want to after paste data automatically chart update to current date,here also I do expand range manually min & max.Pls guide me. Regards A

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

2011-10-15 Thread dguillett1
Thanks Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Saturday, October 15, 2011 12:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dynamic chart range Very excellent Example Don Sir... Masterpiece.. On Sat

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

2011-10-15 Thread NOORAIN ANSARI
> =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 > *Sent:* Saturday, October 15, 2011 8:09 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$E

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

2011-10-15 Thread dguillett1
: 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 Sent: Friday, October 14, 2011 9:49 PM To: excel-macros

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

2011-10-15 Thread ashish koul
http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html On Sat, Oct 15, 2011 at 8:19 AM, NOORAIN ANSARI wrote: > Dear Atul, > > Please see attached sheet with Dynamic Chart example. > > -- > Thanks & regards, > Noorain Ansari > *

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

2011-10-14 Thread NOORAIN ANSARI
Dear Atul, Please see attached sheet with Dynamic Chart example. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 13, 2011 at 5:32 AM, Atul wr

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

2011-10-12 Thread Sam Mathai Chacko
Another faster method would be =Sheet1!$A$1:INDEX(Sheet1!$A$1:$A$1000,COUNTA(Sheet1!$A$1:$A$1000)) OR for a more expanded range =Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A)) Regards, Sam Mathai Chacko (GL) On Thu, Oct 13, 2011 at 8:17 AM, rajan verma wrote: > You can use Offset Func

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

2011-10-12 Thread rajan verma
You can use Offset Function to Create Dynamic Name Range and can use this Range as Chart Data Source =offset($A$2,,,Counta($A:$A),counta(ROw(2)) Create a New Name Range and put this Function there .. On Thu, Oct 13, 2011 at 5:32 AM, Atul wrote: > Hi All, > I want to make chart range dynamic

Re: $$Excel-Macros$$ Dynamic Chart

2011-08-02 Thread Chandra Shekar
Hi Haseeb, Thank you very much its working fine. Thanks, Chandra Shekar B On Tue, Aug 2, 2011 at 7:53 PM, Haseeb Avarakkan wrote: > Hello Chandru, > > See the attached. If doesn't have 12 entries it will adjust to available > entries. If do have more than 12 week entries will show the last 12

Re: $$Excel-Macros$$ Dynamic Chart

2011-08-02 Thread Haseeb Avarakkan
Hello Chandru, See the attached. If doesn't have 12 entries it will adjust to available entries. If do have more than 12 week entries will show the last 12 week data. HTH Haseeb For tips visit; http://www.excelfox.com/forum/ --

Re: $$Excel-Macros$$ Dynamic Chart

2011-08-02 Thread Chandra Shekar
s. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Chandra Shekar > *Envoyé :* lundi 1 août 2011 12:02 > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Dynamic Chart

RE: $$Excel-Macros$$ Dynamic Chart

2011-08-01 Thread Daniel
Hi, See attached workbook Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Chandra Shekar Envoyé : lundi 1 août 2011 12:02 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Dynamic Chart Hi, I needed data

RE: $$Excel-Macros$$ Dynamic Chart

2011-08-01 Thread Rajan_Verma
See if it hels From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, August 01, 2011 3:32 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dynamic Chart Hi, I needed data for 12 weeks. In attached file I

Re: $$Excel-Macros$$ Dynamic Chart

2011-08-01 Thread Chandra Shekar
Hi, I needed data for 12 weeks. In attached file I need chart for 30th - 41st week. If I enter 42nd week data I need chart from 31st - 42nd Week chart. Thanks in advance. On Fri, Jul 29, 2011 at 5:47 PM, Rajan_Verma wrote: > *See the attached Workbook* > > * * > > * * > > *From:* excel-macros@

RE: $$Excel-Macros$$ Dynamic Chart

2011-07-29 Thread Rajan_Verma
See the attached Workbook From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, July 29, 2011 7:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Chart Hi, Can u pls help me in doing dynamic chart

Re: $$Excel-Macros$$ Dynamic Chart

2011-07-29 Thread ashish koul
see if it helps On Fri, Jul 29, 2011 at 7:28 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Can u pls help me in doing dynamic chart in attached file. I tried using > formulas which is in attacthed file. But I could not able to do the same. > > I need only 12 weeks data in th