View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do you extend the trend line?

Double click on the trendline, on the Options tab, adjust the backward entry
in the forecast box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"kim tt" <kim wrote in message
...
I need to extend the trend line beyond 0 on the x-axis (into the negavtive
region) how do i do this?