MrExcel Publishing
Your One Stop for Excel Tips & Solutions

trendlines


Posted by Mark Whitby on January 21, 2002 2:10 AM

I am trying to obtain a expression of a data set that i know is exponential on a linear plot.
I have plotted the data on a log scale, to give me a linear relationship, i want to find the equation of the straight line on the log plot.
Everytime i do this it flags a fault, saying that i either have to plot positive numbers (which i have) or change the scale which i do not want to do.
Please help!!!!!!


Posted by Mark W. on January 21, 2002 7:06 AM

Add an Exponential trendline and on the Options
tab check the "Display equation on chart" check
box.