Formula to calculate the Maximum and Minimum values for the x and y Axis

What I desire excel to do is explained on the attached 2010 excel sheet.

Please advise if these desired actions are acheiveable and if so- the cost, if additional software is needed and an approx ETA for your solution(s).

AttachmentSize
For_Excel_guru_from_Jeremy_Plooy(1).xlsx13.54 KB
Nick's picture

deriving formulae for quartic equations in Excel

Hi Taz
deriving formulae for quartic equations is a big topic, and I recommend that for the best value for you to contact the author of this:
http://newtonexcelbach.wordpress.com/2010/09/19/complex-numbers-and-solv...

- A significant amount of work has gone into solving your problem... It may not match the algorithm used internally by Excel's graphing module, but should be close.

Rgds
Nick