| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Function to Match Power Trendline in Chart?
Hi, I'm using the "Power" trendline in an XY scatter chart and want to use the formula and the rsquared result in a worksheet. What worksheet function can I use to to show the function (or it's components) and the rsquared within the worksheet? (The formula stated on the chart is: y = 644.691x^-0.895) I've looked at LINEST but that seems to only give a straight line trend? LOGEST gives me the exponential result? Basically I'm worried about using the rsquared value from the chart if I don't have it through a function as well. Anyone able to help? Thanks! -- acjim ------------------------------------------------------------------------ acjim's Profile: http://www.excelforum.com/member.php...o&userid=24487 View this thread: http://www.excelforum.com/showthread...hreadid=381152 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fan charts | Charts and Charting in Excel | |||
| CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
| Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) | |||
| Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
Threaded Mode
