Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to extract a chart trendline formula into a cell

Status
Not open for further replies.

GTstartup

Electrical
Mar 5, 2005
422
Is it possible to take a chart formula based on a trendline and put the formula in a cell(s) so I can use it to calculate Y values for any given X? I would like to be able to separate the individual components of the formula into different cells

For example

y=.6x+50 would be

A1: 0.6
A2: 50
 
Replies continue below

Recommended for you

Status
Not open for further replies.

Part and Inventory Search

Sponsor