In article , "=?
Utf-8?B?V2lsbGlhbSBTcHVybG9jaw==?=" <William
says...
I want to display a linear trend line to project an end point at a future
time. I have a fixed starting point and want a linear extrapolation from
that point. The standard linear trend line moves the start point to give a
straight line fit to the data, but that's not what I am trying to do.

To specify a particular intercept, double-click the trendline, then
select the Options tab. The rest should be straightforward.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions