MrExcel Publishing
Your One Stop for Excel Tips & Solutions

trendline with custom equation

Posted by Apparao on July 25, 1999 8:35 AM

Can somebody help me in creating a trendline with equation Y = a + b*1/X.
Excel does linear equation Y = a + b*X
I would appreciate any help in this regard.

Posted by Ivan Moala on July 28, 1999 1:21 AM

Excel also does Logrithmic, power, exponetial,
polynomial and moving average that you can access
by right clicking on the data graph area.
If you wanted to plot these as per your formula AND you have your graph setup from your data table
then setup another data table with your values, select the Y value range and Drag this to your Graph.