trendline equation coefficients
Posted by Greg Walton on January 28, 2002 10:55 AM
Excel will display chart trendline equations on its charts. I type the coefficients into cells and use the formaulas in the spreadsheet. However, the coefficients change each time the chart data changes and I have to retype the coefficients into the cells each time this happens. Where does excel store the trendline coefficents? I want to refer to these storage locations in the cells and have excel update the coefficents for me rather than retype them each time by hand. Thanks for the help.