| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I increase the of significant digits given in the slope i.
Does anyone know how to increase the number of significant digits given for
the slope of a trendline in the trendline equation in Excel? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
Right click on the displayed equation and Format Data Labels|Number
Alternately you could use the worksheet functions SLOPE and INTERCEPT or LINEST for more complicated models. Jerry mcozbyl wrote: Does anyone know how to increase the number of significant digits given for the slope of a trendline in the trendline equation in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate a forecasted increase using a Absolute Ref | New Users to Excel | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
| Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
| How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
| Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) | |||
Linear Mode
