View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Trendline formula does not mimic actual trendline

Hi Ottmar,

Am Thu, 24 Sep 2015 11:14:00 -0700 (PDT) schrieb BottleMan:

I use Excel 2007. Maybe that is the problem. I just repeated the entire operation and the result is the same.


the best and exactest trendlines you get with XY (scatter) charts.
I made some test and I guess you have a line chart.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional