Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is the problem as it stands:
First some sample data: 02/05/07 88.9% 02/12/07 80.6% 02/19/07 85.8% 02/26/07 84.4% 03/05/07 93.0% 03/12/07 90.6% 03/19/07 96.3% 03/26/07 87.0% 04/02/07 90.4% 04/09/07 91.0% 04/16/07 84.7% 04/23/07 91.7% What Needs to be found: Based on the trend when will the utilization go above 95% based on a linear growth trend. Why: I need to graph a bar indicating when that 95% mark is met (for capacity planning.) How did this come about: Normally I throw on a trendline and manually move a marker. I would rather, for the sake of accuracy have the indicator plotted. Any suggestions? All I need back is the date this happens (I'll be setting the bar to 100% manually as to make a wall) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A formula that autofills by trend rather than linear | Excel Discussion (Misc queries) | |||
A formula that autofills by trend, not linear | Excel Discussion (Misc queries) | |||
Linear Regression using the TREND function | Excel Worksheet Functions | |||
How do I anchor one end of a linear trend line? | Charts and Charting in Excel | |||
intersection with linear range as true argument | Excel Programming |