Excel - plot for multiple values of x

[scooterscot]

Is it possible? Possible to plot from a single formula calculated multiple times over for where x-0.....6 for example?

Really want to avoid going into matlab, which seems overkill.

[malvolio]

Is it possible? Possible to plot from a single formula calculated multiple times over for where x-0.....6 for example?

Really want to avoid going into matlab, which seems overkill.

Yep. Start reading up on Array Formulas...

[scooterscot]

Yep. Start reading up on Array Formulas...

Oh no, not those. It's a valid point right enough, but you have to trigger them every time you wish to calculate if I remember.. but that might not be a bad thing. Thanks.

[d000hg]

May have mis-read but can't you add a column with the input values you want to use, and another with the formula values for those inputs, and feed that into a graph?

Not very elegant but wouldn't it do the job?

[scooterscot]

May have mis-read but can't you add a column with the input values you want to use, and another with the formula values for those inputs, and feed that into a graph?

Not very elegant but wouldn't it do the job?

Not when the formula has 20+ coefficients, too much scope for human error at that point. Also I'd like to test for different coefficients, not always the same one. Matlab is good for this but is overkill and expensive to maintain.

[Pondlife]

Can you give us an example?

[scooterscot]

When excel fails me I turn to Grapher. The amount of times this little app has saved my bacon. In this example Sc is calculated 50 times over for sequential values of x.

[jamesbrown]

If you need to do these sort of things regularly, consider R (Matlab is fine too, as is the open-source version, Octave, but R is extremely powerful and has a massive user community). It will take you a while to learn, but it's almost never "overkill" vs something like Excel, because you could do this in a couple of lines of script, rather than faffing with cells and formulas in Excel.

[scooterscot]

If you need to do these sort of things regularly, consider R (Matlab is fine too, as is the open-source version, Octave, but R is extremely powerful and has a massive user community). It will take you a while to learn, but it's almost never "overkill" vs something like Excel, because you could do this in a couple of lines of script, rather than faffing with cells and formulas in Excel.

I never expected to get a hit googling 'R'!

I'm guessing you mean: The R Project for Statistical Computing

[jamesbrown]

I never expected to get a hit googling 'R'!

I'm guessing you mean: The R Project for Statistical Computing

Sorry Yes, exactly. It takes a while to learn, since it's all script-based, but it's incredibly powerful and widely used, with an excellent user/support community. It's pretty much the standard for statistical computing (the proprietary equivalent of the R language is S-plus in case that rings any bells..).