Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using LOOKUP instead of IF on dynamic row | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
Indirect and dynamic ranges | Excel Worksheet Functions | |||
Trend Lines (or Linest?) | Excel Worksheet Functions |