View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Helbron
 
Posts: n/a
Default Trendline Question

My chart is a scatter plot of values (Y) vs. date (X). So, to answer your
question, no, since I don't know how to handle dates in the function
calculation. As far as the "ranges" being "big enough", how do I check this?

Bill

On Wed, 8 Mar 2006 07:27:43 -0600, robert111
wrote:


Have you calculated the trend parameters yourself using slope and
intercept functions? If so check your formula ranges are big enough to
capture new data.