Extrapolate to zero (n) rather than forecast x units

It would be useful when adding trend lines to be able to set 'extrapolate to
a number' rather than 'forecast x units along'. This would allow you to click
extrapolate to x=0 so that the trend line can be seen back to the axis. It
also means that you don't have to calculate the difference between the last
data point and the point you wish to extrapolate to.

Thanks
--
Dave_S_UK using Excel 2003

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Getting the y value for x=0 is a simple exercise. Set x=0 in the
regression equation.

--
Regards,

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

In article <[email protected]>,
[email protected] says...
> It would be useful when adding trend lines to be able to set 'extrapolate to
> a number' rather than 'forecast x units along'. This would allow you to click
> extrapolate to x=0 so that the trend line can be seen back to the axis. It
> also means that you don't have to calculate the difference between the last
> data point and the point you wish to extrapolate to.
>
> Thanks
>