Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Accessing trendline data from charts ie equation and r-squared

Posted by David on May 21, 2001 7:35 AM

Is there any way of extracting the fitted trendline equation and r squared value from a chart?

Re: Accessing trendline data from charts ie equation and r-squared

Posted by Eric on May 21, 2001 8:21 AM

After you start the graph wizard, tell it to plot the data without a trend line. Select the graph, then click on "chart" then "add trendline" and on the second tab over "options" click the checkbox to show the equation in the chart. You can treat the formula as regular text (cut and paste).
Hope that helps Is there any way of extracting the fitted trendline equation and r squared value from a chart?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.