Create graph using formulas

[BenEC]

Morning all,

I have a formula in my worksheet which produces a single numerical output from a number of inputs. I want to graph the variation in the output as I modify one of the input values. Is there a way for me to do this automatically without having to manually chnage the input and record the result for each change? Can Excel produce the data range for me?

Many Thanks!

Ben

 

[VoG]

You'll have to store your X and Y values somewhere. See Plot an Equation in an Excel Chart