View Single Post
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Double click the trendline equation; from the Number tab select a
format that lets you specify the number of decimal places.

Alternatively, use the LINEST function to get the value in the
worksheet directly. [In versions prior to 2003, for certain data sets,
the chart trendline gave better results than LINEST.]

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Does anyone know how to increase the number of significant digits given for
the slope of a trendline in the trendline equation in Excel?