Adjust the number of decimal points in Trendline equations

[piapiapia]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In excel, there are different types of charts we can use, one of which is the xy scatter chart. Whenever I use this, i add the trendline. Aside from thet, I also check the boxes for the equation and R-squared value of the line.

However, I get the values upto THREE DECIMAL PLACES (i just need to emphasize) only but I need more decimal places. Does anyone know how to adjust the number of decimal places seen in the equations from the trendline and R-squared values? I really need to know this for my reports in school. Thank you!

 

[CyberTaz]

Control/Right-Click the Trend Line Label, choose Format Trendline Label,
then select Number from the left column of the dialog. Set the number of
Decimals to what you prefer.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[piapiapia]

Thank you very much!