Dynamic Trend
 

I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you
--
Eli Kedar
Israel

Hi,

This can be done with dynamic ranges.
http://www.andypope.info/ngs/ng31.htm

Cheers
Andy

Eli Kedar wrote:
I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Eli,

The examples here might help as well:

http://pubs.logicalexpressions.com/P...cle.asp?ID=518

----
Regards,
John Mansfield
http://www.pdbook.com


"Eli Kedar" wrote:

I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you
--
Eli Kedar
Israel

John

Thank You
--
Eli Kedar
Israel


"John Mansfield" wrote:

Eli,

The examples here might help as well:

http://pubs.logicalexpressions.com/P...cle.asp?ID=518

----
Regards,
John Mansfield
http://www.pdbook.com


"Eli Kedar" wrote:

I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you
--
Eli Kedar
Israel

Andy

Many Thanks
--
Eli Kedar
Israel


"Andy Pope" wrote:

Hi,

This can be done with dynamic ranges.
http://www.andypope.info/ngs/ng31.htm

Cheers
Andy

Eli Kedar wrote:
I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.

Thank you

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info