I have a graph where I have forecasted the trend line to zero on the y-axis.
I want to be able to read/determine somehow the specific value on the x-axis where it crosses it at zero on the y-axis.
Thanks for any help.
I have a graph where I have forecasted the trend line to zero on the y-axis.
I want to be able to read/determine somehow the specific value on the x-axis where it crosses it at zero on the y-axis.
Thanks for any help.
Can you post example of your chart?
Can you calculate this from the trend line equation, or is it horribly complicated?Originally Posted by b0ng0
Here's an example. I just want to know what the value on the x-axis is where the trend line crosses it.
Dear god, TheNorm you're right. Thanks very much, I am shocked I didn't realise this sooner![]()
Pretty.
Maybe this will help
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks