Looks like a bug to me. I've submitted it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"mor" wrote in message
...
Hi
In excel 2007, when I add a trend line to some data to which has
negative x values it always extends the trendline to x=0. This is
quite annoying, does anyone know why it does this or have a fix for
this?
try plotting
-2 -1
-2.1 0
-2.2 1
-2.3 2
and adding a trend line. I've not used the forecast options so I
wouldn't expect it to extend the trend line.
Any help much appreciated.
--
mor