logarithmic regression question

[TCBucher]

Hello,
I am in the process of trying to create an equation for a report I put out daily. My report entails comparing current production runs v. an aggregate average of the fiscal year. I have plotted the data on an x,y chart and found that the logrithmic equation fits the data the best.

Is there a way to extract the equation from the chart? The problem is that each day, more entries are added to my data and the equation changes. I believe there is a way to do this without having to plot the graphs but i do not know how. Any help is appreciated!

Thanks!
Let me know if you need more info.

 

[TCBucher]

Please click one of the Quick Reply icons in the posts above to activate Quick Reply.

 

[PaddyD]

basically you're after a linest(), but all you want to know & more here:

http://www.tushar-mehta.com/publish_train/data_analysis/16.htm