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ł:
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 m7piotrow...@gmail.com
wrote:
WOW. It is illogical but works. I have not known this option. Is it
Dear Amar,
Sorry for being late. Kindly find the attachment.
On Mon, Feb 23, 2015 at 12:10 PM, amar takale amartak...@gmail.com 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
Can any body help me
On Mon, Feb 23, 2015 at 12:10 PM, amar takale amartak...@gmail.com 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
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
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 koul.ash...@gmail.com wrote:
click on the series you will see the
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
Hi,
Am trying to plot dyanamic chart but am having problem with name range if I
try to select correct reference its changing to other reference. Could you
please check attach file and let me know where its going wrong.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or
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 amartak...@gmail.com wrote:
Dear Sekar,
Great!
Thanks a lot,extact which work
Thanks Sekar,I will wait for your reply
On Sat, Feb 16, 2013 at 8:40 AM, RAJA SEKAR apkra...@gmail.com 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
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
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
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 noorain.ans...@gmail.comwrote:
Dear Atul,
Please see attached sheet with Dynamic Chart example.
--
Thanks regards,
: 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
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
Dear Atul,
Please see attached sheet with Dynamic Chart example.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu, Oct 13, 2011 at 5:32 AM, Atul
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 rajanverma1...@gmail.comwrote:
Hi All,
I want to make chart range dynamic For example, range A1:g1
represents series for the first week and I want to extend the range
for the second week means I want to change the range to A1:N1. Please
help me to make it dynamic
Thanks
Atul
--
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 atul_pate...@yahoo.com wrote:
Hi All,
I want to make
** **
*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 for 12 weeks
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/
--
Hi Haseeb,
Thank you very much its working fine.
Thanks,
Chandra Shekar B
On Tue, Aug 2, 2011 at 7:53 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com
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
*
* *
* *
*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
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
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
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 the chart.
Thanks
--
--
Some
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 the
27 matches
Mail list logo