Came across this method recently for graphing a formula, saves space and very efficient.

It uses the undocumented Evaluate() function.

Anthony, can you please explain more.I cant find the evaluate function.I am very interested in this method.Thanks

Apologies, this thread was supposed to have an xls attached to it, i think it must have got deleted at some stage.I've attached a simple xls that was used in the thread ' Mirror a Graph'. Take a look in the menu command Insert - Name - Define. There you will see how the named range Y is setup using the evaluate() function which relies upon the formula entered in cell c3, note that most Excel functions will work in the formula but user defined ones wont, which is a shame. Also take a look at how the chart is calculated, i.e. it is based upon the named ranges x and y which are arrays. There are also more sophisticated things you can do to replace x in this example by using the offset() function to produce an array of numbers within given bounds, that way you dont use any worksheet space. Note that the evaluate() function is not documented, I'm hazarding a guess that it is used internally for the regression functions.hope this helps.

Thanks AnthonyIt is really good.I am not sure I understand the second curve on the graph.One of the curves is the resulte of the evaluation of the function defined but dont know what the other curve is.

There are 2 series X and Z. The X series is the one on the worksheet and the Z series is generated as its inverse using the evaluate() function and the formula in cell c3.