Hi.

I've been asked (work) to try and get excel to generate the individual values of an equation of a line that has been plotted on the graph.

It is a quadratic 3rd order plot. y=X3+X2+X+C.

I have used the =Linest function to get the X3, X2 and X constants. I can not figure out how to get the C from the plots equation.

The reason for this, is so that x values that are found can be imported and use the pulled out values to calculate y values.

I have been told that you can put the 0 for x. I also have a foud y value for 0 but this does not give me the same values. I know they are close but that can't fly.

Is there a way to get this C value?