#1
|
|||
|
|||
Excel Trendlines
Is there any way I can have a trendline that doesn't forecast either backwards or forwards? I just want the trendline to go between the data points and nothing more.
Thanks in advance. |
#2
|
|||
|
|||
If you select one of the series, I guess it looks like img01 below.
Drag the handles of your values selection and the trendlines will be limited to your selection, see img02 below. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
VBA code from Excel 2007 in Excel 2010 | csam63 | Excel Programming | 1 | 10-07-2011 10:46 AM |
Excel Hyperlinks crash Excel programme | martinlest | Excel | 8 | 01-26-2011 04:23 AM |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |