Excel Trendlines

dillonmhudson · #1 02-04-2012, 02:52 PM

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.

pbengtss · #2 02-17-2012, 06:59 AM

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.

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