Axes limits with negative x values and trenline

M

mor

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top